Relationships and Query

A

andrena

I'm learning from Access 2000 for dummies and need to have this repor
done today. I need some guidance. I have two tables:

_Customers_
name
address

_Invoices_
Invoice# (alphanumberic)
Date
Project
Amount

My end result is to be a report with One person's name selected on i
with all the invoices from a certain date. I know I need a query to d
this report. First off I am having touble connecting the relationshi
of these two tables. Can some one tell me how to have a one to man
relationship between these two tables??? Keep in mind every customer i
going to belong to all the invoices in the invoices table. I know ho
you drag one field to the other table in the relationship window bu
not sure if I need to create another field or what. Can't get th
little plus sign to drop down in the Name field to show all th
invoices entered
 
E

Ed

To connect two tables in a query you should have the same field in both
tables in a one-to-many relationship. The Customers table should have and
autonumber field (CustomerID) and the Invoices table should aslso have a
field called CustomerID with as a long integar.
 
Top