Are there any third party tools that allow this?

>No, you can't do that in SSMS, but SSMS is not an end-user tool.
>
>>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.