I use an index to eliminate duplicate data but want the first reco

S

SheilaG

I currently have a table set up with an index that will eliminate duplicate
records when 4-5 field names are equal. With this index, it will not post any
records that it finds a duplicate of when I import data. I want the first
occurance of the duplicate to post to my table. How can I get the first
record to post and eliminate the following duplicates?
 
Top