Hi Bob.

Oops, I missed the last part of your message.

>It seems that, you are not including the tables unless they are open. Also, as I said, there is no join info in SFQuery... so, lets say I have a view of ee_master, and I want to user to be able to specify a filter... They may want to see all employees that have job code 'AC-123'... well, unless the join is included in the cFilter, how do I know they are using fields from the job codes table for the query?

SFQuery is primarily for filters. Because of the way relations work in VFP, you generally can't filter on a condition from a child table (the record pointer in the child table will only be positioned to the first child record for the parent, which may not match the filter condition). That's why the join information is in SFQueryEngine instead.

Doug