Imported field violates data integrity

G

Guest

I am importing from a text field in which the client ID can be duplicated. I
have generated a new table called "tblImportClient" where this data goes.
There is no key field so the clientID can be duplicated. I would like to use
the data in this field using an append qry to append (add clients not
currently in my database) the "tblClient" table in which the clientID is the
key field (not an autonumber). How can I append a new client into the
tblClient so that a client is only added once (so i don't violate the key
field rules for the clientID). Thanks for any help.
 
T

tina

just run the Append query, from tblImportClient into tblClient. you'll get
an error message saying that not all records can be added due to a key
violation, and asking if you want the query to run anyway. click Yes, and
the non-duplicate records should be added just fine.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

prevent duplicates in table 1
Missing records when they're there 2
Criteria in append querie 3
opening data entry form with appropriate client ID fillied in... 1
Message from importing an excel file 8
Getting the autonumber value after adding new record when dao points to SQL rather than JET 3
Create fields in multiple tables using import 2
Combo box and table relationships doesn't work as expected 7

Top