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 <[email protected]> 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)
> ...)
