So I have another post here that is somewhat related, but wanted to start another thread since this question is a bit different. This is the layout I am currently working with that is tied to my "Fam2" table:
The goal is that when I enter a First/Middle/Last name for either Parent 1 or Parent 2, a record in the "Ind2" is created with the same name. The same is true for a child's name that is entered into the portal. I read through some other posts about auto-creation, but couldn't quite figure out how to apply them to this situation. Below is also some information about tables/relationships. I am not quite sure what I need to relate to what... and when it is related, under which table would I allow creation of records?