Hi Rob,

Primary and foreign key fields all end in "ID". Primary keys should be
autonumber and foreign keys should be Number - Long Integer. The primary key
of each table is the first field under the table name. All other "ID" fields
in each table are foreign keys and have the same name as their related
primary key. So to set up the relationships connect all foreign keys to
their appropriate primary key. Let me know if you don't understand.

Steve


"Rob H" wrote in message
...
Steve,

This looks like a very well laid out set of tables. I was having problems
getting the relationships set up for three tables, this will surely drive
me
crazy. Can you take me one more step?

I've been watching a tutorial but it goes over this pretty quickly and
with
a small set of tables.

Rob

"Steve" wrote:

Rob,

How about these tables ........

TblAgeGroup
AgegroupID
AgeGroup

TblIncomeGroup
IncomeGroupID
IncomeGroup

TblCustomer
CustomerID
name, address, phone, etc
Gender M/F
AgeGroupID
IncomeGroupID

TblProduct
ProductID
Product

TblCustomerPurchase
CustomerPurchaseID
CustomerID
CystomerPurchaseDate

TblCustomerPurchaseDetail
CustomerPurchaseDetailID
CustomerPurchaseID
ProductID
Size

Steve




"Rob H" wrote in message
...
What I would like to do is create a database to track sales, customer
info
and customer demographics using 3 separate tables: Customer Info(name,
address, phone, etc.), Sale info(what was purchased, date, size, etc),
and
Demographics(Gender, age, income, etc). I have the three tables
populated
with the needed fields but I'm having a problem creating the
relationship
setup so that I can say look up a customer or product and see what
product
that customer purchased or select a product and see which customers
have
purchased it.
This is a beginner question, which I am, but would like a little help.


.