Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can entity relations span different pages?

Status
Not open for further replies.

frrrostie

MIS
Jan 3, 2004
2
US
I am working on a large ER diagram that would take more than one page to draw. I've been unable to make a relation between entities that are on different pages. How can this be done? Thanks
 
Try to use bigger page size.
Your page size will be contain 2 or 4 print pages.
Go to File>Page Setup... next Page size
Set Custom Size
If you use A4 paper, set 390 mm x 564 mm.
If you use Letter paper, set 15 in x 19 in.
 
what do you mean by "make a relation"?

Its easy to get data out of one shape on one page and put it into another shape on a different page: create a shape shape1 on page1 with user defined property prop.prop1 and on page 2 create a shape shape2, then e.g. in the text area of that shape select insert->field->user formula->=pages[page1]!shape1!prop.prop1
 
Regarding "what do you mean by a relation?":
An ER diagram is an Entity/Relation diagram. This type of diagram is used to model databases. The relation is depicted by the "connector" between the entities. It is more than just a line. It implies a specific logical relationship and invokes rules to insures the integrity of the database. Visio can then check the integrity of your design and generate an error list to alert you to potential problems. When you have a correct ER diagram, Visio can generate the code necessary to construct or alter the database.

Thank you for the suggestions. I had been using the "big page" solution to solve this problem.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top