Creating a form for data entry on three tables

[Gamermom]

Hello,

How do I create a form that will allow me to enter data into three different tables?

I have a rather simple database for tracking students. When I get a new student I need to take information off their paper application and enter it into three separate tables, Student, Families, and Demographics. Each of these tables contains the fields StudentID, StudentFirst, and StudentLast.There is a relationship between the StudentID field on each table, with Student being the main table and Families and Demographics coming off of it. All relationships are one to many. StudentID is the key for the table Student.

I want to create a form to add a new record to each of these tables. I want my data to be displayed in the Columnar style. I only want to enter StudentID, StudentFirst and Studentlast once and have it populate to all three tables.

I can create a form and a query that displays existing entries exactly like how I want to enter them, but of course I can not edit or add to them. I have tried using subforms, but they don't seem to link up. Once I enter the Name, I want it to be on all the forms. I don't want to have type it three times. I also tried creating three separate forms and connect them with the Navigation Form. The issue again is that once I enter the name in one form, it is not automatically on the next form.

Thanks so much for your help.

 

[Galaxiom]

Each of these tables contains the fields StudentID, StudentFirst, and StudentLast.

That is where you started going wrong. Search the forum and internet for normalization. One you understand this principle and design your tables accordingly, the problem will go away

 

[Gamermom]

Thank you for replying Galaxiom, but I am not sure what you mean. I believe that I have normalized my tables. The StudentID is the unique field used to make relationships between various tables. I need to know the name of each student on a table so I know who's information I am looking at. If I didn't include the name of the student in each table, it would be very difficult for me to view my data.

 

[Galaxiom]

Your tables are not normalized because you have duplicated the names.

Tables are for storing data. Management and viewing of that data should be done in forms and reports. A form/subform structure with the LinkFields properties set for the StudentID is all that is required.