Thanks Massimo
I had a bit of a headache porting it to my big app. The Problem was a
single line:
db.define_table('Taste',
Field('Name',unique=True),
format = '%(Name)s' # <<< important
)
db.Taste.Name.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'Taste.Name')]
db.define_table('Food',
Field('Name',length=128),
Field('Taste','list:reference Taste')
)*
db.Food.Taste.requires=IS_IN_DB(db,'Taste.id','Taste.Name')*
when you remove this line it works but if not you got the same result as if
you had no list.
Pretty weird.