On Monday, July 9, 2012 12:32:11 PM UTC-4, Remco K wrote: > > Thanks for the answers. > > This representation works perfectly when i show the content in a dropdown > so i think this has more to do with SQLFORM.grid... >
The dropdown is controlled by the IS_IN_DB validator, not the field's "represent" attribute. SQLFORM.grid, SQLTABLE, and read-only SQLFORMs, however, depend on the represent attribute. If you set the "format" attribute of the referenced table and do not explicitly set your own IS_IN_DB validator for the reference field, then the reference field will adopt that format attribute for both its IS_IN_DB validator and its represent attribute -- otherwise, you have to handle each separately. Anthony
