PDA

View Full Version : Table Queries / Search Results on Web page


ebook
04-19-2006, 02:41 PM
Can I modify a table search on a page so the visitor uses drop down choices or check boxes to search, instead of typing in text.

For example:

Lets say I have a form filled out on my site that also inserts that data to the database.

(Form information entered)
Name: John Doe
State: Ohio

Now, when I ad the search table to a page, I would like the user to be able to

Click a drop down box titled (state) and when (Ohio) is selected from the 50 states, the record returns: John Doe

Thanks!

Jim Buckler
04-19-2006, 02:48 PM
Yes. When setting up a search file using the Database Manager you can select a field (such as "State") and the indexed names entered in that field will appear in a dropdown box. Every record that has someone from that State would then appear in the search results.