Linking Tables

[exnuke1972]

I am working on a db where I have a main table with a list of all classes offered this term. I have 7 other tables consisting of classes from the main segregated by department.

My question is how do I link these (sub) tables to the main table allowing changes on either the subs or the main to change data on each other?

Any help would be appreciated.

[RayMilhon]

Unless you let us know the actual Data Structure it's impossible to give you good! advice.

Example:

Maintable
field1 number
field2 text

table2
field1 Number
field2 Text

maintable field1 -> table2 field1 (show linked fields)

[exnuke1972]

Structure is as follows

Main
ID [PK] Number
Offer? Yes/No
Course ID Text
Course Title Text
Credit Hours Number
Days Text
Start / End Time Text
Site Text
Room No Text
Stud Cnt Text
Add'l Comments Text

All Subs
ID[PK] Number
Offer? Yes/No
Course ID Text
Course Title Text
Add'l Comments Text
Credit Hours Number
Days Text
Site Text

So far I have one-to-one relationships setup between each of the subs and the main.

[RayMilhon]

First thing you need to do and I put 110% importance on this step is read up on Database Normalization. Before you do anything else you desperately need to fix the Data structure. You want your data in 3rd Normal form.

[RayMilhon]

Take a look at the attached JPG It'll give you a starting point.