Forums

This topic is locked

advanced filter/DB Structure - HELP

Posted 04 Apr 2002 22:50:02
1
has voted
04 Apr 2002 22:50:02 Peter Lent posted:
Hi,

Here is what I am trying to do:

Allow a visitor to select (from a form dropdown list) a certain county on page1.asp

Then submit that form to page2.asp and perform a search and return all the records that contain that county.

Here is the tricky part...There can be more than one county selected per record in the DB. In other words when a user addes there data to the DB, they can select 1-5 counties.

I am not sure of how to set this up in my DB file, or perform the filter.

Suggestions are WELCOME.

THANKS

Peter

Reply to this topic