Creating A Search Form

[crempp]

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.

[Westy]

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

[crempp]

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 . I think this may solve all my problems.

Thanks so much.