Several Fields with Same Unique ID

M

Melynda E.

I have several small tables that house categories of information about our
clients. I would like to pull these details into a subreport for a complete
client overvivew (Client contact information at the top and complete order
history below).

What is the best way to pull all of the order history data from these tables
for each specific client into this subreport?
 
R

Rick B

You have several tables that house categories of information about clients.
What does that mean?

What is the structure of the tables? Do you have a common field
(ClientNumber) in each table? Is there only one entry per client in each
table, or are there more? Could a client have no records for a particular
table?

More details please.
 
Top