Attendance database

[john9210]

FM 12 Adv. I'm trying to setup a database of meetings that records attendance and voting at each meeting. I have a Meetings table and a Names table. On each meeting record I select attendee names from a value list in a Names portal. I would like to include a field to record an attendees vote (yes, no, abstain) but I can't figure out where to put it. I doesn't belong in either table. I then need to create reports that lists the attendees and tallies the voting. I was wondering if I need many-to-many relationship and how I would set it up.

[comment]

16 minutes ago, john9210 said:

I would like to include a field to record an attendees vote (yes, no, abstain) but I can't figure out where to put it. I doesn't belong in either table

That is correct. You need a third table to serve as a join table in the many-to-many relationship between Names and Meetings:

Names -< Attendance >- Meetings

The vote would be recorded in a field of the Attendance table. This is assuming there will be at most one vote per Meeting - otherwise it's more complex.