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