newbie question on database design

[rpatel3680]

I am totally new to this database stuff so please tolerate me.

I have 3 tables:

PrimarySite:
---------------
PID
SiteName
Abbreviation

SecondarySite:
-----------------
SID
SiteName
Abbreviation

TertiarySite:
---------------
TID
SiteName
Abbreviation


each table has unique entries(no duplicates). but primarysite might have multiple secondarysite linked to it. and the secondarysite might have multiple tertiarysite linked to it.

so sample data would be primarysite: hand, secondarysite: nail, tertiarysite: left
and primarysite: foot, secondarysite: nail, tertiarysite: left

how would i link the tables together so that no entries are duplicated but are linked properly? should i create a separate table linking PID to SID? or is there an easier way?

 

[rpatel3680]

oh come on...i'm sure this is a simple answer...anyone?

 

[Aladin Akyurek]

Tables that you have:

PrimarySite(PID,SiteName,Abbreviation)
SecondarySite(SID,SiteName,Abbreviation)
TertiarySite(TID,SiteName,Abbreviation)

Additional tables that you need:

PS(PID,SID)
ST(SID,TID)

Keys are in bold.

You need to link these tables thru Tools|Relationships (preferably before filling in the tables).