I am trying to build a multipage enrollment form that collects parent and prospective student information. The first form collects the information of the parent submitting the enrollment form. The second page collects information about the student being enrolled. The third page collects emergency contact info. The fourth asks parents to sign and agree to the disclosures and program requirements.
The forms themselves have been collecting data from entries just fine. Here's my question: How can I allow the parent to enroll multiple children at once without needing to completely go through and complete the entire form for each child?
The goal is both to expedite the process for parents with multiple children and to tie multiple children to the same parent. The parent table includes an autonumber "parent key." Resubmitting the entire multiform means that parent will be assigned a different "parent key" for each child they enroll, which defeats the purpose of having a "parent key" in the first place.
Any help would be greatly apppreciated!