How to use a form to update a blank table

[Ron Mowry]

im trying to figure out how to create a adhock ticketing system through ms access. I have my main table with 20,000 records. Some records may not need to be modified some may need to be and others may need to be duplicated. What I would like to do is create a blank table in the same structure as the original with no records. Then do an unmatched query between those 2 tables so it would catch the records that have been worked already. I would then create a form based off my unmatched query but I would like the form to then update the blank table. The problem I am running into is that I do not know how to make the form update the blank table it is just appending the main table. Could anyone shed some light on this quandry I have?

[Mariostg]

What is the query(ies) you use to update your "blank" table?
If you use an UPDATE query, you have to specify two tables (SELECT table1, table2) and use the SET command to update the fields in say table2 based on matching records between table1 and table2. If your blank table is empty, you cannot match anything obviously.

I am not sure you state your problem clearly.

[Ron Mowry]

I was using the unmatched query as a checksum making sure the records are not being worked twice since once they are populated into both tables the find unmatched query will not grab records that show in both tables.

[Mariostg]

What is the data source of the main form? From what you say in your original post, looks like it is linked to the main table. If that is the case, it cannot update the blank table.

[Ron Mowry]

I just want it to pull from the main table and update the second table with any modifications leaving the main table unmodified. I would then use the unmatched query to eliminate reworking the same records.So I assume from what you are saying that it is not possible to do this?

[Mariostg]

Well, anything is possible, but probably unlikely with this approach. From what I understand, your form is linked to the main table and you want that any changes made within the form takes place in the blank table rather than the main table. To do this you would likely have to use an unbound form. It would populate from the main form but redirect the changes to the blank form...

If the only reason for keeping the main table untouched is to be able to identify which record has been updated then maybe creating an additional field in this table, let's call it isUpdated would be a better approach. Set its value to 1 if updated, 0 otherwise.