Thanks a lot Candid , it works fine with me
On May 27, 3:39 pm, Candid <[email protected]> wrote: > db.ticket.type.requires = IS_IN_DB(db(db.type.deleted == False), > 'type.id', '%(name)s')) > > On May 27, 3:25 am, Neveen Adel <[email protected]> wrote: > > > Hello, > > > i have table > > > db.define_table("type", > > SQLField("name", "string"), > > SQLField("deleted", "boolean",default=False), > > ) > > > and > > > db.define_table("ticket", > > SQLField("name", "string"), > > SQLField("type", db.type ), > > ) > > > // here in ticket will display a drop down of types, i want that drop > > down to have only the un-deleted types (means deleted = false) > > > how can i do this? > > > Thanks
