Need way more information, I have no idea what's going on.

Is first and last name in every table on it's own, or is it a proper relationship with an ID?
What is actually happening with "does not update", is it a text box and you can't edit it? Or it lets you type and doesn't save? Or what's going on? Are there any errors?
Are all 7 tables and forms active at once? Do they all have this problem?

Sorry :( I was trying not to write a deposition and am over frustrated and assuming everyone has access on the brain
A picture says more - I added name to 1st table and expected auto fill of student id and names in the rest. When I realized i had not set the relationships, I went in to find out they will not link if I select reinforce referential integrity

I created a junction table as was described in one of the tutorials ( i think this one - https://www.youtube.com/watch?v=etdKwDqNFxg&t=3s, ) but am having issue there also (this table can be seen in the pic above also)
the idea was a navigation form for the 7 forms with save button for user and the auto fill of name in each table and form for reference for user and audit. I can add a pic of this also if needed

Hello Wendy,

If I understand correctly, you have StudentAccountID, Child First Name and Child LastName in each table individually.
Then Access probably treated it as if these could also be different first and last names.
But the information is actually already available in 01_General Information, isn't it?
Then they are no longer needed in the other tables.
I would also take the opportunity to change Child First Name and Child LastName so that there are no more spaces, e.g. ChildFirstName and ChildLastName.
I'm also not quite sure whether the StudentAccountID refers to the respective child that has ChildFirstName and ChildLastName as its name.
If not, the table relationships should be reworked so that the relationships work better. :-)

Thank you Lars. If I am understanding correctly, I am trying to force ( 3 ) different foreign keys per table and can only (and only need ) ( 1 ). Is this what you are saying? I have assumed I could use (3) and this is the premise I worked with. So in this case the student ID should be the only foreign key that connects all the tables?
Then, I should use the FirstName/LastName from the GeneralInfo table in all the forms instead of what I have currently?

Yes, exactly. You only need one.
The complete name is always the same redundant information. You just need the ID for the entity "student".
You could (!) use several. And sometimes that makes sense.
But only if the information is different, e.g. student and vaccination.
However, this kind of information usually comes from different tables.

What do your forms look like?
For example, do you have comboboxes to display the name of the student?
Then the combobox data can be taken from 01_General_Information:
1st column: StudentAccountID, 2nd column: ChildFirstName & " " & ChildLastName [or something similar]
1st column is hidden, 2nd column is then displayed

The beauty of a relational database is that you usually only have to enter the information (such as the complete name) in one place.

But that's something you get used to over time. :-)

I tried pulling the names and the relationships still did not work with the tables. I thought I understood relationships and am seriously thinking I am missing something :(
I did not use combo boxes for the students as I assumed the names would be able to be pulled via a report as they will not be known until a student enrolled.
Here are the pictures you asked about. > I put notations in them for better understanding. each form is independent of each other to be able to pull JUST vaccine info or general info for teachers etc. (plus i did not want to have a table with 200 fields to it :( )
My goal is/was enjoying the beauty of the relationships and only adding the names 1x and it just populating inside the forms and tables if needed for data report and such.

Hi Wendy,

have you seen this video by Richard about Relational Combo Boxes?
https://599cd.com/blog/display-article.asp?ID=1752

This shows quite well how you can insert the student's name in other forms without the number of fields for the form having to become confusingly large.

In your case, the StudentAccountID should actually be enough for the ConsentInfo_F. Similar to the CustomerID in the video (approx. minute 16)

"I did not use combo boxes for the students as I assumed the names would be able to be pulled via a report as they will not be known until a student enrolled."

But the ConsentInfo_F has the student's name at the top, right?
Then I would perhaps first try out whether it works to get a corresponding combo box with the name of the student on the ConsentInfo_F.
The combo box gets its values from General_Information table, the ConsentInfo_F would then only need the StudentAccountID.

Lars,
Thank you. I have not yet. I will do so and let you know. Its on my list of videos to watch as I am trying to figure this out ;)

Question: A navigation form is not recommended in the training videos (I don't remember if a 'why' was given) but in this case, would it be better if I did another menu type form vs. navigation form for a new student set up?

Hello Lars,
I apologize for delay.
There is someone helping me with this at the moment, I will revert back later to update this. I did not want it to just stop without sharing this with you.
A relational combo-box is nice but an auto-fill scenario is in line with what I am trying to accomplish. I haven't found a training video on auto-fill, do you know if one exists?
(ppsssttt....wink wink @Richard if it doesn’t exist already lol)  

Hello Wendy,
Are you thinking of something like this video for "Push a Value"?

https://599cd.com/blog/display-article.asp?ID=3416

Lars
Maybe? Let me check .
I am not sure why I didnt get notice you sent this, I have to look at what I may have turned off :(
I did make a relational combo box that works on a different form but I will check this out - it sounds like it may be what I am seeking :)

Lars Yes - this is in line with what I was thinking! Thank you :) Guess my vocabulary is not up to par hahaha - not auto fill but push | pull | populate instead :)

Thank you!!