Hi David,
use any query in combination with widget e.g.:
q=db.person.name.like('A%')
r=db(q).select(db.person.id,db.person.name)
db.table2.person_id.widget= lambda self,value: SELECT
(_name='person_id',*[OPTION(e.name,_value=e.id) for e in r])
you can also build the validator:
db.table2.person_id.requires=IS_IN_SET([e.id for e in r])
Notes:
- you have to handle the special case where r is empty.
- _name in SELECT is required, otherwise appadmin does not work
(@developers: should appadmin.insert check form.errors ?)
Denes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
