Update Record button

[Steven.Allman]

I have two forms that have a relationship of "ID#"


When you press a button on Form1, it opens Form2, to matching record for ID# from Form1. Form2 information is manually inputted the first time if there is no record. I want to create a button to look at a Table2 I have with ID#, to pull the information for Form2. I made this work quite easily. However, here is my real dilemma. Table2 is updated by an outside source on a regular basis, and that data will disappear once the employee leaves the company. For my purposes, I need to ratain that information. Hence I need the button to update a Table3, rather that just Form2. Form2 can then get the info from table3.
Does this make sense and does anyone know what i am talking about and how to make that happen"??

[Steven.Allman]

Lets look at this another way.
I have information about incidents. The incident info does not contain personal information. There is an ID number that links the incident to the person involved. I have a table that has the personal info in it. I click on my form1 button and it shows me form2, which is ONLY personal info, nothing about the incident. The only relationship is ID#. I have a new database, which I created a linked table too. It contains personal information for every employee. I want my button to do the following


Incident #235 from table1 open on form1 (works)
click button to view personal information regarding incident #235 (works)
'Does personal information exsist for ID#235
if yes, open form2 goto record #235 (works)
if no, open form2, populate from table 3 using ID#235, retrieve personal info and add information to new record on table 2 (NEEDED)

The reason I cant use this table3 and just it, is that personal information is deleted when the employee leaves the company, but if they are involved in an incident, I must retain there personal information