getting started

T

tommmm

I am new to access. I have imported a unique table of customers and a table
of records covering multiple customers. I want to be able to look up a
customer and get all the records for that customer to list but cannot seem to
get it to work.
 
S

Steve Schapel

Tommmmm,

How do the records in the second table identify which customer they
relate to? Is there a CustomerID field or some such, by which the
second table can be related back to the Customers table? If so, you can
make a Query, which includes both tables, joined on the CustomerID field
(or whatever it's called) from each. And then you will need a Criteria
in the query in order to select the data for the specific customer you
want. One way this is often done is to have a form, with an unbound
combobox where all customers are listed. You can select a customer in
this combobox, and then you would refer to this in the query criteria,
using syntax the equivalent of this...
[Forms]![NameOfForm]![NameOfCombobox]

Hope that helps. If you need more explicit help, can you post back with
more details of your tables please?
 
Top