>From the way it looks to me is that if it requires it to be in the database then of course it can not be empty. You've already solved your own problem?
On Mar 6, 11:44 am, raven <[email protected]> wrote: > I have a field that references another table > > Field('material', db.material) > > I can get SQLFORM to give me a drop down list of available material > names > > Field('material', db.material, > requires=IS_IN_DB(db,'material.id','material.name')) > > I can get SQLFORM to insist on filling the field > > Field('material', db.material, > requires=IS_NOT_EMPTY()) > > I would like to get both at once. However > > Field('material', db.material, > requires=[IS_IN_DB(db,'material.id','material.name'),IS_NOT_EMPTY()]) > > does not show the drop down list. > > The problem seems to be in placing IS_IN_DB inside a list, > because this does not work > > Field('material', db.material, > requires=[IS_IN_DB(db,'material.id','material.name')]) -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.

