[web2py] Smartgrid: How to make value from foreign table appear in table when only foreign key is in table

[Alex Glaros]

Instead of *db.Word.dictionaryTypeID* displaying (which is a foreign key in 
db.Word), I’d like a value from the foreign table to appear, i.e., 
DictionaryType. dictionaryName.


In the example below, when user cascades down to the Word table, it only 
shows db.Word.dictionaryTypeID but I’d like to add the corresponding 
DictionaryType. dictionaryName value to it.


def search_lang():  

   grid = SQLFORM.smartgrid(db.HumanLanguage, 
linked_tables=['Word','DictionaryType'], fields = [db.HumanLanguage.id, 
db.HumanLanguage.languageName, db.Word.id, db.Word.wordName, 
db.Word.definition, db.DictionaryType.dictionaryName,

       *db.Word.dictionaryTypeID*],

       user_signature=False)

   return dict(grid=grid)


id<http://127.0.0.1:8000/tech_dictionary/default/search_lang/HumanLanguage/Word.languageID/1?keywords=&order=Word.id>
  
  
Wordname<http://127.0.0.1:8000/tech_dictionary/default/search_lang/HumanLanguage/Word.languageID/1?keywords=&order=Word.wordName>
  
  
Definition<http://127.0.0.1:8000/tech_dictionary/default/search_lang/HumanLanguage/Word.languageID/1?keywords=&order=Word.definition>
  
  
Dictionarytypeid<http://127.0.0.1:8000/tech_dictionary/default/search_lang/HumanLanguage/Word.languageID/1?keywords=&order=Word.dictionaryTypeID>
1 beaker    glass jar     1


Want to replace the "1" under Dictionarytypeid with value from foreign 
table.

Thanks, 

Alex Glaros

-- 

--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.