Several Fields with Same Unique ID

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

Guest

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a field to Query 2
Total Query 3
query drops records 2
Query for two fields in one record that do not match 3
Count Unique Records 2
Run multiple queries from control button on split form 1
Query that references a field ID(P_K) to filter data from other ta 1
3 Tables and query not updateable 1

Back
Top