Creating A Search Form

Classic Servoy
1

I am having trouble finding the best way to implement a form for creating lookups.

I have created a form with fields that will be filled in with the search criteria. Then when done searching I would like the result to be displayed in a list (portal) on the same page. Also I need the ability to go through the list and manually omit records.

I don’t know the best way to do this. I figure storing the foundset in an array or in a lookup table i created on the database would be a good idea.

2

Have you seen Matt’s excellent “Cool RapidSearch Technique” movie at:

http://forum.servoy.com/viewtopic.php?t=611

It’s tops.

The only thing I would add is that you can also easily re-use a search form over and over again for different situations by hiding, showing, and repositioning fields and other form elements on the fly. Servoy’s great!

Dean

3

That video is great, I would love to see more. It cleared up a few points on searching for me. In the video it looks like he has a form based on the table of the “mag_users” which is what he is searching through. He arranged the form with a header for all the details of the selected user and the body is the list of users that show up in the search. I never thought of using a header in this manner :oops: . I think this may solve all my problems.

Thanks so much.