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 --