question on multiple occurances
If I have a person in my database who is a member of more than one committee, how do I represent that? Example, I have three different committee names and this person is a member of all three. If I have a tab name Committees on each employee record, and a field for Committee on that tab, how do I have them assigned to each committee so that if I print a report, they appear in each committee on the report? Do I set up a Committee Table and have it related to the main table?
Thank you in advance.