I've been having a heck of a time trying to figure out how to make a simple drop down list from a table in the database.
What I would like to do is have a drop down list populated by the table information and when a person selects that item from the drop down I want it to go to a page that pulls up all of those types of items. I've seen reference to IS_IN_SET() and IS_IN_DB() but it doesn't make much sense to me since there are a lack of examples. This is what I have so far on it. def get_services() services = db(db.services.name>0).select(orderby=db.services.name) form = SQLFORM.factory(SQLField('name', label='Select a service',requires=IS_IN_SET(services))) return dict(form=form) default/get_services.html {{=form} This does create a drop down but it has a bunch of extra information about query and lambda which I don't need and only displays about half of the names in the table. I just need the name and the ID like a normal dropdown list with auto submit. Has anyone a reference to something like this? Thanks, David