 <p>Well I usually use the object explorer and go to the table I want and then look under Keys. You can widen the object explorer to see the fullname of the key. If it is named properly it probably has the table name of both the primary key and foreign key tables in it. If not you can script it to see. I had to search to find this relationships window you were talking about becasue I would never use the design window as we script all changes.</p>