Thread
:
Relational Database Layout
View Single Post
#
2
March 7th, 2010, 06:01 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
Posts: 1,017
Relational Database Layout
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.
Steve[_77_]
View Public Profile
View message headers
Find all posts by Steve[_77_]
Find all threads started by Steve[_77_]