KeithI've got a way to handle this exactly, but am not going to have time until next week to share. If you want, please feel free to bug me about it next week (after Monday) and I can put together what I have and send it off to you so you can see it.
Here is a screen shot of what mine looks like. I'm using SQLFORM.factory to generate my 'search' form.
Again, I'm buried with stuff this week thru Monday. I can help if Tuesday is soon enough.
-Jim
On 6/14/2012 12:00 PM, Keith Edmunds wrote:
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
-- Jim Steil VP of Information Technology Quality Liquid Feeds, Inc. 608.935.2345 office 608.341.9896 cell
<<inline: iihgejfa.png>>
