Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Hide relationship/FK lines on diagram?


This question is answered.


Permlink Replies: 5 - Last Post: Jan 27, 2015 6:26 PM Last Post By: Jason Hahn
Patrick Demets

Posts: 12
Registered: 5/22/14
Hide relationship/FK lines on diagram?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 15, 2014 9:14 AM
Hello, is there a way to hide (i.e., not display) relationship lines and foreign key constraint lines on a diagram? I have a Data Source entity that feeds in to each other entity in my data model, and all the relationship lines are causing much visual chaos on the diagram. I'd like to not show these relationships on the diagram, but keep them defined in the data model of course. I've got a goofy workaround, where I colour each relationship line the same as the diagram background colour, but that seems like the wrong solution. Any ideas? Thx
dean siewert

Posts: 21
Registered: 9/24/10
Re: Hide relationship/FK lines on diagram?
Correct
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 15, 2014 2:30 PM   in response to: Patrick Demets in response to: Patrick Demets
I haven't run across any option that lets you choose whether to display relationship lines in a model/submodel. I do like your solution. Maybe not as elegant as you wish, but very functional. It made me think of the option of choosing a color only slightly different than the background color so I would have "shadow lines" for tables that get joined all through the model.... Still there but less imposing.

The trick that I've used when I have a table that joins to almost everything is to have that fully described in the Main Model, but then have sub-models without that table so I have more clarity when I'm looking at a specific subject area.

It looks like you could use the Color property in the RelationshipDisplay Object to control the color of the relationship lines within a single sub-model... I haven't played with that, but I think you could write a little script that essentially would turn your relationship lines on-and-off.
Patrick Demets

Posts: 12
Registered: 5/22/14
Re: Hide relationship/FK lines on diagram?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 16, 2014 9:09 AM   in response to: dean siewert in response to: dean siewert
dean siewert wrote:
I haven't run across any option that lets you choose whether to display relationship lines in a model/submodel. I do like your solution. Maybe not as elegant as you wish, but very functional. It made me think of the option of choosing a color only slightly different than the background color so I would have "shadow lines" for tables that get joined all through the model.... Still there but less imposing.

The trick that I've used when I have a table that joins to almost everything is to have that fully described in the Main Model, but then have sub-models without that table so I have more clarity when I'm looking at a specific subject area.

It looks like you could use the Color property in the RelationshipDisplay Object to control the color of the relationship lines within a single sub-model... I haven't played with that, but I think you could write a little script that essentially would turn your relationship lines on-and-off.

Thanks Dean, those are the two options I've explored as well. I find that colouring the lines to make them invisible sometimes trips up the auto-routing of other lines. I prefer creating a submodel without the much-used entity (as you suggested). Since ER/Studio logical data models have entities fully attributed, the propagated foreign attribute(s) indicate well enough what's going on. Thanks.
Patrick Demets

Posts: 12
Registered: 5/22/14
Re: Hide relationship/FK lines on diagram?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 16, 2014 9:26 AM   in response to: Patrick Demets in response to: Patrick Demets
Patrick Demets wrote:
dean siewert wrote:
I haven't run across any option that lets you choose whether to display relationship lines in a model/submodel. I do like your solution. Maybe not as elegant as you wish, but very functional. It made me think of the option of choosing a color only slightly different than the background color so I would have "shadow lines" for tables that get joined all through the model.... Still there but less imposing.

The trick that I've used when I have a table that joins to almost everything is to have that fully described in the Main Model, but then have sub-models without that table so I have more clarity when I'm looking at a specific subject area.

It looks like you could use the Color property in the RelationshipDisplay Object to control the color of the relationship lines within a single sub-model... I haven't played with that, but I think you could write a little script that essentially would turn your relationship lines on-and-off.

Thanks Dean, those are the two options I've explored as well. I find that colouring the lines to make them invisible sometimes trips up the auto-routing of other lines. I prefer creating a submodel without the much-used entity (as you suggested). Since ER/Studio logical data models have entities fully attributed, the propagated foreign attribute(s) indicate well enough what's going on. Thanks.

And the other I should have mentioned is that I put a very visible note (highlighter yellow) on each diagram, listing the entities/tables that are not shown for clarity's sake.
Colin Davies

Posts: 1
Registered: 11/21/09
Re: Hide relationship/FK lines on diagram?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Dec 29, 2014 3:54 PM   in response to: Patrick Demets in response to: Patrick Demets
I have run into the same problem. I have a single Physical model with several submodels that share entities/tables, but I don't always want to see all the relationships in a given submodel. I couldn't make this work using a single Physical model. The approach I have taken is to create all the necessary relationships in the Logical model, but instead of creating a single Physical model with multiple submodels, I generate a new Physical model for each of the former submodels. In other words, I don't use submodels much at all. This allows me to delete relationships from a Physical model without these changes propagating anywhere outside the current Physical model. It's a bit of a workaround, but it works for me.
Jason Hahn

Posts: 10
Registered: 10/12/08
Re: Hide relationship/FK lines on diagram?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 27, 2015 6:26 PM   in response to: Patrick Demets in response to: Patrick Demets
I'm probably missing something here, but you can choose whether to include relationships in a given submodel. When in the submodel editor, expand a parent entity on the "Selected" side to reveal the relationships underneath. Select the relationship you want to hide and move it back to the left.

When creating your submodel initially, be sure to uncheck the option to automatically bring over relationships. You still must be careful not to select the relationships when selecting the entities to include (shift-select often includes hidden relationship nodes in the tree), but this sounds like it might be what you want in a submodel.

If this is too time consuming, it's also possible that a macro could automatically do this for all relationship displays in a submodel.

Cheers,
Jason

--
http://community.embarcadero.com/index.php/forum/data-modeling-architecture

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02