onClick command to insert data from one dataset to another

Hi Steve, thanks for the hard word. Unfortunately, this is not what I’m trying to do. Especially regarding hover functions.
l’lI try to imge my explantions and going chronologically:

1 - People can sign in and create a personal profile. They become then, Candidates. Thir info is obviously logged in the Candidates table.
2 - after sign up, they can acces a profile page called Candidates Update. This generates a new userID updated by the candidate.


3 - I also have a data entry page called Cadidates signup form. This is where I have a challenge to upload info in 2 tables at once.


PS it is normal if you find the input field strange… they’re in French LOL

Thanks again Steve