>Hello group,
>
>I will be useing VFP 6.0 as a front end and SQL server 7.0 as the back end.
>
>I am suppose to combine data from 10 different school systems on 10 different SQL servers. The primary key is suniq. Which of course may or may not be unique through out the system.
>
>Would I be better of using SQL server 7.0 to accomplish this or use VFP 6.0?
>
>Any hints on how to combine data and change the duplicate suniq in to unique suniq.
>
>Thanks
>Jim
One solution is to have a composite primary key: include a second field that indicates the school system, and give it a value "1" for the first, "2" for the second, etc.
The combination of school system + suniq would be unique.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
