Ross,
You still need a Primary Key to be able to determine which of the duplicates gets the First id or the second or the thrid ...
For example:
|
person_id |
identification_id |
id_code |
class_code |
status_code |
good_flag |
proc_type |
id_number |
|
279864 |
|
MC# |
|
|
|
|
P039619 |
|
390500 |
|
MC# |
|
|
|
|
487968 |
|
314814 |
|
MC# |
|
|
|
|
272614 |
|
354545 |
|
MC# |
|
|
|
|
389499 |
|
354545 |
|
MC# |
|
|
|
|
389499 |
|
365062 |
|
MC# |
|
|
|
|
417392 |
|
316109 |
|
MC# |
|
|
|
|
227649 |
|
340139 |
|
MC# |
|
|
|
|
227649 |
|
317049 |
|
MC# |
|
|
|
|
278249 |
|
348927 |
|
MC# |
|
|
|
|
374367 |
of the two higlighted rows how would you tell which gets 1 and which gets 2 ?
* Noel