I need a parent to be able to check in their student for school. They come in, enter the kid's ID number, click Submit, and the student is checked in for the day.
I have two databases (forms):
Student
This contains the Student's ID number and their first and last name. It is the REFERENCE table.
Check In
This is the check in form. This is the TRANSACTION table.
I want one screen where they enter the Student's Number and hit Submit. This looks up the Student's Name in the REFERENCE table and passes the values (Student ID and Name) to the TRANSACTION form so that everything is pre-populated (set as READ ONLY fields) and the parent only has to click Submit to check-in the student.
Thank you.