It exists productClass.rebateClassId.requires = IS_EMPTY_OR(IS_IN_DB(db, db.productClass.productClassId))
On 11 jul, 23:33, Jim Steil <[email protected]> wrote: > Hi > > I have a situation where I have a field that is referencing a field in > another table. I added the .requires = IS_IN_DB to get CRUD to create > the dropdown for selection of the field. But, that's not really what I > want. I would like the dropdown to get generated in CRUD, but for the > field to not be required. Here is the code that I have now, > rebateClassId is the field I'm talking about. I want the dropdown > generated but it can be left blank. > > productClass = db.define_table('productClass', > Field('productClassId', 'id'), > Field('productClass', length=4, required=True, > unique=True, label='Product Class'), > Field('name', length=50, required=True, unique=True), > Field('tracksTons', 'boolean', required=True, label='Tracks > Tons'), > Field('rebateClassId', 'reference productClass', > label='Rebate Class'), > Field('rebateSequence', 'integer', label='Rebate Sequence'), > Field('productClassGroupId', db.productClassGroup, > label='Product Class Group')) > > productClass.productClass.requires = [IS_NOT_EMPTY(), > IS_NOT_IN_DB(db, 'productClass.productClass')] > productClass.name.requires = [IS_NOT_EMPTY(), > IS_NOT_IN_DB(db, 'productClass.name')] > productClass.rebateClassId.requires = IS_IN_DB(db, > > db.productClass.productClassId, > '%(name)s', > zero=('select rebate > class')) > productClass.productClassGroupId.requires = IS_IN_DB(db, > > db.productClassGroup.productClassGroupId, > '%(name)s', > zero=('select product class group')) > > -- > Jim Steil > VP of Information Technology > Quality Liquid Feeds, Inc. > 608.935.2345 office > 608.341.9896 cell
