I must be missing something here, following my other post, I have fixed my problem with storing attandance records by not using a composite key and by just storing people how don't attend, makes things much easier!
tblMembers stores member details
tblParade stores who is on duty for that parade, looked up from the tblMembers table
tblAttendance stores data on who has leave for that parade, looked up from tblMembers along with the date from tblParade
I can add records in frmParade fine (frmAttendance as a sub-form), but when I leave the form and go back to modify them, I get:
"The record can not be deleted or changed because table "tblAttendance" includes related records"
Heres the db, it is over the max file size for here
Database
tblMembers stores member details
tblParade stores who is on duty for that parade, looked up from the tblMembers table
tblAttendance stores data on who has leave for that parade, looked up from tblMembers along with the date from tblParade
I can add records in frmParade fine (frmAttendance as a sub-form), but when I leave the form and go back to modify them, I get:
"The record can not be deleted or changed because table "tblAttendance" includes related records"
Heres the db, it is over the max file size for here
Database
