>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 <ravenspo...@yahoo.com> 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 web...@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.