Update Query?

[Eric]

I need some help getting my head around "How to do this".

I have a MS Word User Form that exports information (a full report) to an
Access Dbase. Upon completion of the Template Report the user exports all to
Access. Each report has a unique "Report_ID". I then have Append Queries
that take the data from the import table and populate several other tables to
break the data out for use throughout the dbase. (The New Record in the
Import table is no longer needed). The other tables being updated from the
import table have the Primary Key set to the Report_ID, but currently I do
not have a Primary key in the import table. I do this to allow the User to
Re-Export the report if their report changes and they need to modify their
report prior to finalizing the report.

My problem is with Duplicate Records through out the other tables. The
other tables won't allow another append query, do to the Primary Key. I can
also use a delete query for the import table after the append queries run.

But to allow for a second import/append, should I use an Update Query?

Any thoughts would be greatly appreciated!

Thanks