Hey guys, i'm kinda stuck on this little problem which probably is easy but i can't figure it out.
I have two tables that are linked together with a primary key "ActionID" which is an auto number.
What I need to do is copy all the records that have the "Ongoing" field checked to the same field and change it's "Year" field.
The method that I chose to do this is from the first (parent) table run a query that pulls all the "Ongoing" records. I then append those records back into the table. Those records are assigned a new "ActionID." Here's my problem, i need to copy and append all of the records on the second (child) table to itself as well. How do i do it so that the new appended records of the 2nd table will have the same ActionID as the new record in the 1st table so that they will be linked together. Nehelp would b much appreciated. thanks
I have two tables that are linked together with a primary key "ActionID" which is an auto number.
What I need to do is copy all the records that have the "Ongoing" field checked to the same field and change it's "Year" field.
The method that I chose to do this is from the first (parent) table run a query that pulls all the "Ongoing" records. I then append those records back into the table. Those records are assigned a new "ActionID." Here's my problem, i need to copy and append all of the records on the second (child) table to itself as well. How do i do it so that the new appended records of the 2nd table will have the same ActionID as the new record in the 1st table so that they will be linked together. Nehelp would b much appreciated. thanks
