Hi All I'd like some advice on the best approach to building a search form. I don't think crud.search is right, but I'm not sure whether I should approach this using a SQLFORM or SQLFORM.factory or some other way.
The model includes an 'activities' table that has a date column. There's also a 'customers' table, and the standard auth_user table. I want to build a form that has a date selector for 'from date', another for 'to date', a combo for 'user' (populated from auth_user) and a combo for 'customer' (populated from the customer table). The resulting query will be fed into a SQLFORM.grid, if that's important. Any pointers to a good way of doing this? Thanks, Keith -- We're looking for good Linux people: http://www.tiger-computing.co.uk/jobs