Hello, here is my question. I am creating a personnel tracking program. Due to security issues, and to make a more referential db, I am keeping Social Security Numbers and Dates of Birth in a table separate from the personnel non- secure information (name, address, phone numbers). This is also done to be able to restrict the users who can see the secure data.
What I want to do is this. SSN's will be periodically inputed into the SSN_DATA table (before the personnel arrive for their first day of work). When the person shows up for work, they go through a check-in process with HR where we will collect all of the pertinent data on the individual. There is a button with the caption "Add New", when pressed, this button brings up an input box asking the user to input a SSN. Problem: This inputted SSN needs to be found in the SSN_DATA table, its id column int retrieved, new row created in MAIN_DATA table, and the id int of the SSN inserted into MAIN_DATA.ssn_id. i'm not sure how to accomplish this. it all needs to happen behind the scenes and return the user to the main form on the correct new row in the MAIN_DATA table so the user can continue checking in the person.
