Table linking

[peterbowles]

hi,

I could do with some help to link tables, can't seem to get it right.

Table MAIN ROUTER

Router No
Router Address
Site Contact
Site Tele

Table SITES

Site_IP_address
Site_Name
Site_Contact
Site_Address

Table NETWORK

Network_Number
Network_Name


It should work like this,

Table MAIN ROUTER can have Many SITES and table NETWORK will show Many MAIN ROUTERS,

Many sites can belong to one! Main router, Many MAIN Routers can belong to one Network

Thanks for any help

 

[JACKSON]

I would add a Router_Number field to the Sites table, and a Network_number field to the Main Router table. I would make both of those fields look-up fields and browse to the appropriate table and select the field. In this way you are linking the tables together. Good Luck

 

[sjdibben]

I would say take out the site_contact and site_tele and put them in the site table. Otherwise you will have repeating attributes if a site has more than one router, and you're storing the same information twice.