On Jun 3, 10:26 am, Jean Guy <[email protected]> wrote: > Hi, > > I would like to know if there is a way as simple of "requires = IS_IN_DB" to > show a dropbox of what is already in my table, but without the need of > requiring that field be entered in my other table. I have many fields that > need dropbox but they are not all used at the same time (nulls fields : not > normalised table)... > > Hope I am clear! > > Here an example : > > db.define_table('person', > SQLField('fname'), > SQLField('lname'),format='%(fname)s %(lname)s') > > db.define_table('dog', > SQLField('name'),format='%(name)s') > > db.define_table('cat', > SQLField('name'),format='%(name)s') > > db.define_table('ownership', > SQLField('person', db.person), > SQLField('dog', db.dog), > SQLField('cat',db.cat)) > > db.ownership.person.requires = IS_IN_DB(db,'person.id','%(fname)s > %(lname)s') > db.ownership.dog.requires = IS_IN_DB(db, 'dog.id', 'dog.name') > db.ownership.cat.requires = IS_IN_DB(db, 'cat.id', 'cat.name') > > I would like to be able to add the relation between person and dog without > have to enter a cat in the case of person that has no cat.
"A person either has no cat, or the cat's information must exist for them to own it": db.ownership.cat.requires = IS_NULL_OR( IS_IN_DB( db, 'cat.id', 'cat.name') ) Does that help? Regards, - Yarko > > Thanks. > > Jonhy
