# Select tables in ERD that makes sense

**URL:** <https://forums.visual-paradigm.com/t/select-tables-in-erd-that-makes-sense/14334>\
**Category:** Feature Suggestions\
**Created:** [July 20, 2018, 6:51pm UTC](https://forums.visual-paradigm.com/t/select-tables-in-erd-that-makes-sense/14334 "2018-07-20T18:51:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vassilios\_Vescoukis](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/vassilios_vescoukis/32/3171_2.png) [@Vassilios\_Vescoukis](https://forums.visual-paradigm.com/u/Vassilios_Vescoukis)\
**Post date:** [July 20, 2018, 6:51pm UTC](https://forums.visual-paradigm.com/t/select-tables-in-erd-that-makes-sense/14334/1 "2018-07-20T18:51:47Z")

</div>

Hello there.

I am using VP to reverse engineer a database, so the ERDs I get are quite a mess (lots of tables, overlapping relationships etc).

It would be nice if I could select one table, right click, and have an option to select the related tables.

It should be already there, actually, it is really simple and useful.

Thanks!

Vassilios

---

<div class="post-metadata">

**Author:** ![antony](https://forums.visual-paradigm.com/user_avatar/forums.visual-paradigm.com/antony/32/2411_2.png) [@antony](https://forums.visual-paradigm.com/u/antony)\
**Post date:** [July 21, 2018, 9:27am UTC](https://forums.visual-paradigm.com/t/select-tables-in-erd-that-makes-sense/14334/2 "2018-07-21T09:27:26Z")

</div>

HI Vassilios,

- Suppose this is your ERD, and you want to see only A and its related entities:

![image](https://forums.visual-paradigm.com/uploads/default/original/2X/2/2829dae8b299a57b93196de939bc4c8aff4a5ddf.png)

- Then just select A and copy it (Ctrl-C), create another ERD and paste it (Ctrl-V).

- You see an ‘a’ indicator appears, it means the entity A now has multiple views, and the just pasted entity A is an auxiliary view.

- Mouse over the entity, you would see the “Visualize Related Model Element” resource. Click on it.

![image](https://forums.visual-paradigm.com/uploads/default/original/2X/6/612e256f4fdb71805895858e745220d1f6134a73.png)

- It analyses and reports which model elements are related to entity A, just select those you interested and click “Visualize”.

![image](https://forums.visual-paradigm.com/uploads/default/original/2X/6/6cd13126b5ec46c1ab39c93ed18df0da4baf6a55.png)

- And as what it promises, it visualizes them on the diagram.

![image](https://forums.visual-paradigm.com/uploads/default/original/2X/a/abd0ddd3ee347e26bd0565444ede97432d547300.png)

I hope this method would solve your problem.

Cheers,

Antony.