[web2py] Re: Referring to a table to populate a drop down in a FORM

[Tim Richardson]

On Wednesday, 21 November 2012 22:56:43 UTC+11, Niphlod wrote:
>
> SQLFORM.factory(Field('mydropdown', requires=IS_IN_SET(('a','b','c'))))
>

Thanks. 
for my future reference, this code below does exactly what I want. 
 
  
Field('Commission_set',requires=IS_IN_DB(db1,db1.com_general_settings.id,'%(cmsn_set)s
 
%(cmsn_set_desc)s')) 

I haven't used SQLFORM.factory before. Looks like I lose the functionality 
of keepvalues=True

--