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 > --