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
--
