Add search feature to DB Multi Record Loader form

I've got a DB Multi Record Loader using the data displayer to display a table of our internal office directory. I'd like to add search capabilities to it but I'm running into a wall.

I was able to create a completely separate form where I've manually created a table for display and successfully added search capability. However, I'd really prefer to use the data displayer for the sorting and pagination. I just can't figure out how to properly combine search fields with the multi db record form. Any help would be greatly appreciated. Thanks!

Is it even possible to spit out search results using the data displayer? If I create a text box for First Name (fname) and another text box for Last Name (lname) and then submit, can I use fname and lname in the WHERE box for the DB Multi Record Loader?

I apologize for my ignorance and thank you for any input.

Justin

Hi Justin,

I haven't done much with this but I think it should work OK if you set the form to re-load itself. You can display the form with a set of results below it.

Use the results from the submission in the WHERE box to activate the filters you need.

Bob