I need help Pls!!!

[ScottGem]

You are close, but it looks like you have joined PhoneID to studentID. You should have a join table that links the phoneID to the student since its possible that multiple students might have the same phone #

 

[jsanders]

You may want to consider adding a table Family (or something close) because you could potentially have more than one student from a family

This table would be the parent table for the child table tblstudent.

Phone numbers, address, and other info, of this nature would reside in the family table.

Plus a reliable way to search records is by using a telephone number (customers usually always know their phone number) so you could make a form Families with a subform Student. You could search this form with a drop down list displaying phone numbers.

Double click the student (field) that was returned by a search and open a form for that student (This requires some code).

Just a thought.