Search on three data fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hope I can explain this correctly.

I have a database with 5 tables. All five tables have the same three fields
that make up the primary key. I want the three fields, when combined, to be
a Case Number.

I want a user to be able to search on the Case Number and bring up all the
data associated with the case.

I have a main form with a subform. The subform has a subform.

I have no idea where to begin. Is it possible? Please say yes :).
Thank you,
Wendy
 
In design view of the query grid FILED enter --
Case Number:[YourFirstField]&[SecondField]&[ThirdField]
In the CRITERIA below the above field enter --
Like [Enter Case Number] &"*"

This lets them enter a partial Case Number to get all with that part or just
use --
[Enter Case Number]
for a requirement to enter the exact number.
 
Back
Top