Relationships - Confused
Here is what i have and what i want to do (im sure its simple enough and im just missing something)
Two tables one named - "Members" one named "Duties" neither are related at the moment.
I want to be able to assign many members to one duty:
Say for example a duty record is a Football match i want to be able to assign members to that duty and then subsicwently create portals, reports etc from that info.
What am i missing, i cant seem to fiquire it out.