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
>

-- 



Reply via email to