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.


.