ERRATA: do this:
db.define.table('basic' Field('name1') ...,format='%(name1)s') db.define.table('advanced' Field('name2',db.basic) ...,format=lambda row: db.basic(row.name2).name1) # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s') db.define.table('data' Field('something',db.advanced) ...) but this is going to be SOOO slow. You are making two select per each row in the dropdown. On Nov 4, 8:59 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > do this: > > db.define.table('basic' > Field('name1') > ...,format='%(name1)s') > > db.define.table('advanced' > Field('name2',db.basic) > ...,format='%(name2)s') > > # db.advanced.name.requires=IS_IN_DB(db,'basic.id','%(name1)s') > > db.define.table('data' > Field('something',db.advanced) > ...)