Mullti-page ERD


  • I'm creating an ERD that needs to span multiple pages. However, it appears Visio 2010 does not have a mechanism for representing a relationship between two entities on different pages...or am I missing something?
    Mittwoch, 18. August 2010 12:43


Alle Antworten

  • Hi,


    You may check the following link for this issue:

    The strongest link: the Off-page reference shape in Visio


    Hope it helps.


    Best Regards,


    Sally Tang


    • Als Antwort markiert Sally Tang Dienstag, 24. August 2010 09:20
    Donnerstag, 19. August 2010 08:04
  • I am having the same problem in finding the off page reference in Visio 2010. The above link only applies to Visio 2003. When can I find the off page reference in Visio 2010?




    Dienstag, 19. April 2011 20:15
  • It's in the stencil Basic Flowchart Shapes.


    Regards, Paul Herber, Sandrila Ltd.

    • Bearbeitet Paul Herber Mittwoch, 20. April 2011 08:38 edit
    Mittwoch, 20. April 2011 08:36
  • The Off Page reference doesn't maintain the Foreign Key relationship to an Entity, it's only for navigating between pages. The only way I have managed to do thsi so far is to copy and paste the off page entities and colour code them to show they are off page references. Ideally I want to be able to link accross pages. It's easier to have split parts of my diagram into Party, Order, Products, Promotion, Messaging, etc. I currently have 21 pages and over 170 entities.

    In 2010 you can have a much larger "Page" so that might be an answer and then have the printer print it on A4 pages. Then maybe the only issue is labelling for each of your pages which will have to sit within the very large page.

    Donnerstag, 21. April 2011 07:21
  • In MS Visio 2010 or 2007. In Visio 2007 goto the Database menu View>Tables and Views once you can seen the list of tables and views you can go to the page you want to link the table to as well and drag it from the list to the new page and it will keep all previous relationships and will dynamically update on both pages for anychanges made to it on either page. In Visio 2010 goto the Database tab and check the Tables & Views and do the same as above. I hope this helps someone with this issue.
    • Als Antwort vorgeschlagen TTrout Dienstag, 26. November 2013 20:10
    Montag, 22. Oktober 2012 20:34
  • @Jerry921: This solution also works for us ancient users of Visio 2002! and is just what I was looking for.


    Dienstag, 26. November 2013 20:11
  • @Jerry921: Thank you, your suggestion saved the bacon.
    Mittwoch, 6. Juni 2018 15:59