>>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?
That part was the easiest. I mean as far as just creating SQL Server tables and copying the data from VFP to SQL. Now setting primary keys and RI will take a little more time. But I believe the most time intensive is writing the application. Especially since I am trying to do it in .NET :).
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham