Novice - design assistance required

  • Thread starter Thread starter Mark Phillips
  • Start date Start date
M

Mark Phillips

Hi
I have a database in which I store a list of organisations in one
table, a list of members in another table and tie them together with a
list of memberships in a separate table to create a many-to-many
relationship (so each organisation can have many members and each
individual member may belong to many organisations.)

Now, each organisation has ONE secretary (who may or may not be a
member of that particular organisation (professional secretaries) but
will be a member of at least one organisation). Each member may be
secretary of of none, one or many organisations.

Here's the question:-
Do I need another table to identify the secretary of the organisation?
(many to many)?
OR can I link directly from the organisation table to the members
table (one-to-one)?
OR
can I add an entry to the organisation table to identify the
secretary?

Any suggestions gratefully received.
TIA
Mark
 
I would use your last suggestion.
Add a field to your Organizations table, which will hold the Primary Key of
the record in Members for the secretary of that organization.

HTH
- Turtle
 
Back
Top