Thread
:
Relational Database Layout
View Single Post
#
3
March 8th, 2010, 05:37 PM posted to microsoft.public.access.tablesdbdesign
Rob H
external usenet poster
Posts: 35
Relational Database Layout
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.
.
Rob H
View Public Profile
View message headers
Find all posts by Rob H
Find all threads started by Rob H