I am trying to make a form in access to register new parents with their students. The Student can be an adult or a child. The table will allow me to input new students without parents.
I want to set the form up to where I "Montgomery Rachel" already exists in the database with her information (phone# address etc) it will autofill that data.
For tblStudents
--- StudentId AutoNumber
StudentLastName Short
StudentFirstName Short
Age
Phone#
Address
ParentId_FK
For tblParent/Guardian
guardianId_ PK
Guardian1_last Name
Guardian2_first Name
PhoneNumber_1
Guardian2_last Name
Guardian2_first Name
PhoneNumber_2
Address
Would I have to use a query to get the results?
I have looked online for a guide but most only use the Id to where the user inputs the Id and gets the autofill data. I like to autofill the data via their last name and first name