please use format as record representation or set it on IS_IN_DB form 
validation.
e.g. if you want to show city as a drop down menu in order_bus form :
db.define_table(
    'route',
    Field('city'),
    Field('country_iso'), format = '%(city)s')

db.order_bus.depart_from.requires = IS_IN_DB(db, 'route.id', '%(city)s', zero 
= T('choose one'))

db.order_bus.arrive_to.requires = IS_IN_DB(db, 'route.id', '%(city)s', zero 
= T('choose one'))

ref:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Record-representation
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Database-validators

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to