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