this code works great: requires = IS_IN_DB
db.define_table('HumanWord',Field('wordname','string'),Field('languageID','reference
HumanLanguage'),Field('comments','string'),Field('personID','reference
auth_user'), redefine=True)
db.HumanWord.languageID.requires = IS_IN_DB(db, 'HumanLanguage.id',
'%(languageName)s',zero=T('choose one'))
Is this all I need?
Thanks,
Alex
On Tuesday, January 15, 2013 1:12:45 PM UTC-8, Alex Glaros wrote:
>
> I am correctly getting a dropdown choice for referenced field personID for
> fields below in database admin. But why am I not getting a dropdown
> choice for fields *wordID* and* languageID*? Do you see any syntax
> errors?
>
> db.define_table('HumanLanguage',Field('languageName','string'),Field('comments','string'),
>
> redefine=True)
>
> db.define_table('HumanWord',Field('wordname','string'),Field('*languageID*','reference
>
> HumanLanguage'),Field('comments','string'),Field('personID','reference
> auth_user'), redefine=True)
>
> db.define_table('WordComments',Field('*wordID*','reference
> HumanWord'),Field('comments','string'),Field('personID','reference
> auth_user'),Field('datetime','string'), redefine=True)
>
> Thanks,
>
> Alex Glaros
>
--
