I am trying to make a Swim lesson Database for my Instructors to be able to input new students into a class. Reports will able to print out so I can show the front desk staff to avoid people sneaking into my facility if they are not signed up for a lesson.
I currently have
Tables: Parents, Students, Swim instructors, Swim Lessons.
I basically want to create a form that will ask the user to input:
Students Name, Parents Name( If applicable since we have adult students), Instructors Name (drop down box, relationship), Date registered etc.
The form would take these inputs and update each of the tables for their respective info.
What would be the best approach for this? Would I need to use an update query as the form?