How to Make an Entry in a Table and Do it in Another

[iAmRonald]

well typically its not going to be used as a customer system.

its a hospital system

when a new patient comes in the hospital gets necessary data like name and etc but they dont need data like diagnosis/cause of death
and etc.

so those info that are not needed in the initial input, i separated in another table, so the reason i want to link those 2 table is to make sure that when the info gets edit/updated, i can easily locate it using the primarykey in table 1 to any other table.