Relationships

Hi Tania,

I should first make it clear that I am a delegate like you not a tutor. Incase you are still looking for help I am willing to try and help. You have mentioned three tables that you have.

All of your tables should have a primary key field, which should be Long Integer type. If table 'A' is linking to an intermediary table or to any child table, then the primary key in table 'A' will link to a field that is NOT the primary key in the other table (lets call it 'B'). The link field in table B will be a long integer field placed in the table specifically for the purpose of linking to table A.

For the members and subs tables these would probably be best linked as many to many with and intermediary table. Although subs as a many table without intermediary is also possible.

With regards to committes this depends whether you are talking about committee meetings, about which members belong to which committees or both. To simply keep records on who belongs to which committees then this will be one to many with members being on the many side, and the committees being a look-up table.

I hope this helps.

Regards, Mark