Problem Quering Multiple selections in a select box
Posted on 2001-06-05
I have three tables
Cutomer: Has all the usuall customer info
Product: this has a list of 730 products and topics that could be searched on
Custprod: has the both primary keys of the previous 2 tables as FK.
Now I would like to be able to search for a topic then populate a select list based on the privious search string(done that successfully)
now my problem is when I select multiple(single choices work fine)topics I come up with nothing, no record returned but I know that there are record related to all topics selected, can anyone help. I am in a tight spot.