Results 1 to 2 of 2
  1. #1
    cat2610 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Posts
    1

    need help with database design for enrolling students into class

    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. Click image for larger version. 

Name:	data input error.PNG 
Views:	12 
Size:	74.2 KB 
ID:	26538

    I'm suspect this is because the data is not filling into the subtable (roster) for students. See pic below.
    Click image for larger version. 

Name:	missing data in student subtable.PNG 
Views:	12 
Size:	60.8 KB 
ID:	26539
    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

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You cannot add a child record until you save the master record first.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-25-2016, 08:12 AM
  2. Replies: 1
    Last Post: 10-29-2015, 08:36 AM
  3. Working on a database design for computer repair class
    By chrscote in forum Database Design
    Replies: 9
    Last Post: 01-25-2015, 11:12 PM
  4. Creating students database
    By ZA31 in forum Access
    Replies: 4
    Last Post: 03-23-2013, 10:50 AM
  5. Students database
    By berni3883 in forum Access
    Replies: 8
    Last Post: 03-29-2011, 03:21 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums