C
cmarsh
The layout---
5 Fields to be searched pre table
FieldA, FieldB, FieldC, FieldD, FieldE
I have a db with 25 tables. In each of the tables there are multiple
fields, but I only want to search through 5 of them (listed above). I want a
user to select on what field to search and by what criteria (i.e. Where
FieldA=123), and then display this is the report. In the report I want to
display the results, but also other information that attached to the record
or records(date, time, etc.). How would I go about doing this?
5 Fields to be searched pre table
FieldA, FieldB, FieldC, FieldD, FieldE
I have a db with 25 tables. In each of the tables there are multiple
fields, but I only want to search through 5 of them (listed above). I want a
user to select on what field to search and by what criteria (i.e. Where
FieldA=123), and then display this is the report. In the report I want to
display the results, but also other information that attached to the record
or records(date, time, etc.). How would I go about doing this?