Hi Bob.

>The drop down did include the fields from both tables... however, I expected cFilter to include the join information in the cFilter return.

cFilter doesn't contain the join information; instead, use the cSQLSelect property to get the entire SELECT clause (BTW, this is in the SFQueryEngine class; the SFQuery class doesn't do joins). This property gets populated when you call the DoQuery method (if you don't want SFQuery to do the actual SQL SELECT, set the lDoSelect property to .F.).

The join condition is actually stored in a separate property (cActualJoinList), as are the other individual clauses that make up the SQL SELECT statement. However, these are all protected properties to prevent someone from messing them up. If you need access to a specific clause for some reason, you could easily subclass SFQueryEngine and add a method that simply returns the value of the property. In the next major release of SFQuery (which will be for VFP 6), I'm considering making those properties public but have assign methods that make them read-only.

Doug