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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer