Dont give me duplicates

[dbalargin]

I import from info from table Clerical Queue. Once the info in table Clerical Queue is processed, I send this info to another table Archive. The next time I import info into table Clerical Queue, I do not want the info that was previously imported and processed, that is now in table Archive to import again. What do I do? Also, the info is being accessed across a network. One database in one state, another database in another state, etc. .....?

 

[jfgambit]

Is there a unique identifier in the file that can be used as a primary key? If so, setting the Primary key to No Dulipcates in the table should eliminate this problem.

If not are there any fileds that can be combined on import to produce a unique key (for example ProdID, CustID, OrderDate combined could produce 123-6589-030303)

HTH