Hello experts, Generally, when we do a SQLFORM, the 'reference table' fields automatically gets *all* the available options for choosing as a dropdown menu.
However, I would like to get a filtered list instead of *all* of the items. Is there an available function I can use to achieve a filtered list for choosing in the dropdown menu? Another way to look at this is: I would like to generate a SELECT/OPTIONS html using a specific query, i.e. it uses the retrieved Rows to generate the HTML. I wonder if there is a function in web2py for doing this. I hope my question is understood. Thank you. PS. If there isn't an available function, I appreciate any tips or pointers how I can make this work. Thanks! --
