>When you upsize the Visual FoxPro 5.0 database to SQL SERVER or ORACLE database,
>does the joins sections in the local view changes correctly to support the SQL SERVER or ORACLE remote view.

Sonny,
I have used the Upsize Wizard once so far for a fairly small application that was prototyped using VFP 5. For the most part it worked pretty darn well. It converted all of the local views to remote views. And as far as I can remember I didn't have any problems with these views. This was upsized to SQL Server BTW.

HTH,
George