If I'm understanding everything correctly: You just need to handle the button click on PostBack.
On Dec 10, 6:02 pm, martinmike2 <[email protected]> wrote: > 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.
