>Question (for anyone): when looking at a query, how to you know that the query will be correlated - i.e. that for each row of the outer query the inner query is run? Is it triggered by the inner subquery referencing a table in the outer query specifically for a field value in the outer query? Or does VFP just "figure this out"? Would help to know what is going on and whether properly coded - apart from trying to check the resulting data sets.
>

Correlated means that the subquery refers to one or more fields from tables that are in the main query, but not the subquery. However, that tells you nothing about how the engine will actually implement the query.

Tamar