I defined the following table: db.define_table('nav', Field('name',length=32), ... Field('parentID','reference nav',requires=IS_IN_DB(db,'nav.id','%(name)s',zero=T('select a value'))))
In the form I'd like to have a drop box which only contains the navs that have a parentID==0 I guess the following comes close to what I need? IS_IN_DB(db,'nav.id','%(name)s',lambda parentID, row: db(db.nav.parentID==0).select(),zero=T('select a value')) Kind regards, Annet --