Okay, but I have data in the tbPersonnel and in tblMeetings. Therefore why is tblAttendance important? Say we are just beginning the new year and we have meetings scheduled and we have personnel. That would make tblMeetings and tblPersonnel quite important and tblAttendence with no data.
The attendance is recorded as the meetings occur. This is the record source for fmrEmail. Thus prior to the meetings occur we mail invites. Then we they occur we take some form of attendance.
This is mainly as I said a record source for frmEmail. The MeetingID and the MeetingDate are control sources for the respective textboxes in frmEmail.
I just do not know what is going on here.
I would think that I would have with 12 meeting dates and 4 employees that would make for 48 records or slots. The meeting invites would either be filled in or not according to who was invited to the meeting.
I know there is a problem here, it is just I do not know how to deal with it.
Any help appreciated. Thanks in advance.
Respectfully,
Lou Reed