Hi Bill,

PMFJI, but we need some guidance on a 'Too Many Subqueries' issue.

We have a 'task' table that is used two times (alias PickUp, Delivery) The relationship uses an 'and' clause to qualify the relationship. For example, .... FROM Job JOIN Task Pickup ON Job.ptask_ID = Pickup.task_ID AND Pickup.type = 'P' JOIN Task Delivery ON Job.dtask_ID = Delivery.task_ID AND Delivery.type = 'D'.

I think that uses up the two subqueries we are allowed by VFP. If I have need for another (and I do of course) We are greeted with the 'TOO MANY SUBQUERIES' error.

Is there a better approach that will circumvent this issue?

Thanks,

Ken