Meetings

[Raymond Gonzalez]

Hello. In my company we have meetings, every tuesday night and three times on saturday.I want to know how can I record if the members that are in my database have come to every single meeting in a fast and comfortable way. Thank you.

[Fitch]

Create an Attendance table. It should contain the meeting ID and member ID. Create a record for each member each time they attend.

In the Member table, create a calculation: Sum(related::meeting) and then you can compare this number to the number of total meetings expected.