Remove non-visible relationship

[J Walker]

Visio Enterprise Architect
I have a relationship that I deleted from the drawing but
I think it is still in the model. When I execute Error
Check on the model, I receive an error L3002 -
<relationship name>: Child column(s) not specified. When
I right click and select Go To Source I then receive a
dialog box: This relationship is not shown because the
entities it is connected to are not placed on the
diagram.

I have tried to locate the tables (Database, View, Tables
& Views) all tables listed are on the diagram.

How can I remove this relationship?

Thanks
Jay

 

[Mike Ishimitsu[MSFT]]

Jay,

To show a hidden relationship, you can right-click on one of the table shapes that it should be connected to and select "Show Related
Tables." This will ensure that all related tables appear on the diagram as well as the relationships between them. Then you can select
the relationship and delete it. (Before deleting the relationship shape, make sure that the option for "When removing an object from the
diagram" is set to "Ask user what to do" in the Database Modeling Preferences dialog (Database > Options > Modeling).

--
Mike
Visual Studio Enterprise Frameworks and Tools

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they
originated.