def index():
query = ....
db.table.field.requires=IS_IN_DB(db(query),....)
form=SQLFORM(...)
if form.accepts(...)
...
return dict(form=form)
On Feb 14, 3:06 pm, Ed Greenberg <[email protected]> wrote:
> When SQLFORM constructs an HTML form with a dropdown of foreign keys,
> I need to limit the records to only those that match a certain where
> clause.
>
> This is a master-detail problem. For instance, when displaying a
> detail form, we only want some of the maser records to be selectable
> (and even visible).
>
> A crud won't work reliably -- it's too generic. Do I have to create my
> own form and populate my dropdown, or can I have SQLFORM do the work
> in some fashion?
>
> Thanks
> Ed Greenberg
