Of course, our CIO thinks very little of FoxPro and a lot of MS SQL.

We were all looking at some data in in FoxPro today where I had about 6 tables open and all in a relationship to the master table and you move the record pointer in the master table and the rec pointer moves in all the other open tables.

Wow! We use that all the time to troubleshoot data problems.

I am pretty sure you cannot do this in the SQL IDE. Are there any third party tools that allow this?

My Manager said MS Access can. Sure, if you build a form with child forms.