Yes, probably SPT. Right now I'm combining data from 2 SQL-Server databases (not tables) for almost every display, which means getting cursors/views from both and combining. Updating is a nightmare. But with local DBCs which are written programmatically a remote view is really just a pre-designed SPT.
Barbara
>What else would you do 100% SQL Pass through? I am poised at looking at SQL Server or MSDE as the back end replacing VFP tables where all access is defined in the DE of the form.
>
>__Stephen