Thread
:
Relational Database Layout
View Single Post
#
8
March 9th, 2010, 05:04 PM posted to microsoft.public.access.tablesdbdesign
accessnewbie79915
external usenet poster
Posts: 4
Relational Database Layout
Hello, I may be brand new to access myself but the information you posted
about foreign keys and their properties is just plain wrong.
"Steve" wrote:
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.
.
.
accessnewbie79915
View Public Profile
View message headers
Find all posts by accessnewbie79915
Find all threads started by accessnewbie79915