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