'unique' filter question

[russanalyst]

Hi. I inherited some un-normalized tables and need some help.
I have 20 tables each with an ID field and a dozen text fields, each containing unique values.

I need the user to be able to enter the requested ID and the requested value which could exist in any of the fields in any of the tables. And show only the ID and the found values in each table.

I used parameters in every table's query.
But when you enter the ID and then the requested value, I get the ID and every field in that ID's record. No tjust the field with the requested value.

What can I do?

 

[PHV]

What can I do?
Use a normalization UNION query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886