Append to same table
Posted on 2012-09-20
I have a Project form with a subform that store items for each project. For various reasons the query for the subform is made from two tables with a one to one relationship linked on ItemNumber.
I want to be able to copy and append all the current project's subform data into the same tables. I have all the code for appending the project but I need code/query to say copy and append all of the current data in (subform) table 1 and table 2 maintaining a link between the two tables. The link fields are Table 1 ItemNumber (Incremental Number) and ItemNumber (Long Integer) in table 2.
How on earth do you do that?