Hi,
I would like to know what are the steps to make a database of 66 tables searched in one shot?

Does it have to do with parent/child relationships? (even if it does I don't know the proper procedure)

You may have to explain more on that.

_________________________
- Vijay G
Strive for Perfection

Ok. I have a 66 table database. I want the viewer to choose his table to search in. I have an example of the design but need help in the ASP response page:

http://wheelofgod.tripod.com/ASPSearchamos2.htm

the first 6 options are for table columns. Then there is 2 radion buttons which enable/disable the 66 tables.

I was wondering if can come in an "if" statement? If so how would the code be written?