You should add the "format" attribute to the HumanLanguage table definition
in order to tell it how to represent records that reference the table. It
works for the auth_user table because auth.define_tables() does set the
"format" attribute for that table.
db.define_table('HumanLanguage',
Field('languageName', 'string'),
Field('comments', 'string'),
format='%(languageName)s', redefine=True,)
You can also explicitly set the "represent" attribute for the two reference
fields in question.
Anthony
On Tuesday, January 15, 2013 4:12:45 PM UTC-5, 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
>
--