I have a set of models defined as follows: db.define_table('company', Field('name'), Field('symbol'), Field('approved', 'boolean'))
db.define_table('locomotive', Field('manufacturer'), Field('model'), Field('approved', 'boolean'), db.define_table('engine', Field('company', db.company), Field('locomotive', db.locomotive)) The intent of the 'approved' fields are to limit what is displayed to the user in form select lists until they have been approved by someone with an admin role. I am attempting to limit the options in my engine controller create.crud function to only make available the companies and locomotives that are approved. I can obviously get this information easily using db(db.company.approved == True).select() etc. However, I am trying how to figure out how to get this filtered list of options into the select list dropdown in the crud.create(db.engine) form. Any suggestions? I tried to create a custom form to do the same thing, but it began to get really 'clunky'. Thanks in advance for any help! Dave --