I need some help with my database design. I am trying to create a database to manage employees who take several American Heart Classes (BLS, ACLS, PALS, and Heart Saver). I get an error message when I try to enroll the students on the Class registration form.
My goal for the workflow was for the data entry person to import the student roster that is emailed to her from the instructors into the database and append it to the student list. I've built the append query and it works. She can then go to the Class registration form, enter the data for the class and instructors. In the class roster section, I wanted the data entry person to just be able to enter the employee number and have the rest of the data auto populate. I enter all of the data and then I get the error message below.
I'm suspect this is because the data is not filling into the subtable (roster) for students. See pic below.
Have I designed this incorrectly? Is there a better way to do it?
I'm attaching a link to my db file.
https://1drv.ms/f/s!AqFsVz2Lp_RHii6VRfCXfOof5i9X
I'd appreciate any and all help. Thanks so much. cindy