SNIP
>
>However, you are mistaken in the 'assumtion' that you can not use multiple client generated selects with SQL server. You may have to rewrite them slightly, but it can be done.

Always happy to be mistaken in situations like this, BOb < s >.

So you are saying that the following sequence of SELECTs can be sent one after the other to SQL Server and I can expect to get the result I need...
1) SELECT 7 fields from 2 tables based on JOIN/WHERE.
2) Using 1 of those 7 fields, SELECT those fields and 2 others from another table.
3) Using one fo those 2 fields (of the now 9 fields), SELECT using a correlated sub-query on another table.
4) Using the result set from the last SELECT, run another to get the final bits of data I need.

Or maybe I can send them all and just sit back and wait for the result set(s)?

thanks so far.

>
>Of course, SQLs T-SQL with correlated subqueries and derived tables/fields is much more flexible and powerfull than VFP's, and what you may not be able to do in a single select in VFP, you could do in SQL server.
>
>HTH,
>BOb