>I agree with you 100% that having identity field as Primary is better and easier to maintain as far as RI. But my tables were designed when I didn't know this concept (it was about 15 years ago). And now to change from USER-type PK to Entity-type PK could involve some work. I am considering it but need to evaluate if I can do it (in time for delivery).
>
>Thank you.
:o)
Porting tables from VFP to SQL Server also needs some work, didn't it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.