make_a_set = (query) Than use IS_IN_DB(db(make_a_set),...)
Richard On Tue, Aug 28, 2012 at 12:28 PM, lyn2py <lyn...@gmail.com> wrote: > 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! > > -- > > > > --