I have two tables that are initially joined with a nested left join that takes every record from Table 1 and every record related by the [Job #] field from Table 2 and appends them to Table 3 where the [Job #] does not yet exist in Table 3.
After this initial commit, I want the user to be able to open up a form that allows them to move additional records from Table 2 into Table 3 (ones that aren't in Table 1). I'm wondering what the best way to do this would be.
If I could display a list of all the records in Table 2, and the user could just put a check next to them then click "commit", that would be the ideal situation.
I could go into table 2 and add a column with a Yes/No, and then write a query that will append every record from Table 2 to Table 3 that has a "yes" in that field, but I don't know how I can let the user do this through a form and not the table itself. Plus, I don't want to make permanent changes to the source table; I just want to select them in the form interface, but leave them "unmarked" in table 2.
I hope this was a clear enough explanation.