One more suggestion - please add ability in the configuration utility to highlight multiple objects. I need to remove several objects from the Data Dictionary (they are empty tables) and I have to do it one by one.

Downloading new version fixed some of my problems.

But I now can not edit SQL in the VFP window. There is no zoom option (it was in the previous version).

This SQL

select PEOPLE.LNAME,PEOPLE.FNAME, Phones_Home.Home_Phone,Phones_Office.Office_PHONE from People LEFT JOIN (select People.cID, Phones.Phone as Home_Phone from People LEFT join Phones on People.CID = Phones.CID and Phones.Type IN (space(20),'Home') ) Phones_Home ON People.cID = Phones_Home.cID LEFT JOIN (select People.cID, Phones.Phone as Office_Phone from People LEFT JOIN Phones on People.CID = Phones.CID and Phones.Type = 'Office' ) Phones_Office on People.cID = Phones_Office.cID order by 1, 2

produces a syntax error. Do you know what may be wrong?

Ysterday at home I realized, that I was trying to make everything too complex again.

The simpler select should be

select P.LastName,P.FirstName, Ph1.Home_Phone, Ph2.Office_Phone... from People P
 Left JOIN (select cID, Phone as Home_Phone from Phones 
where Type in ... and Phone <> space(60)) Ph1 
on P.cID = Ph1.cID LEFT JOIN () Ph2 ...

So, perhaps I can go with subtables if they allow to introduce filter condition.