Kyle123 i see that you are a very smart guy, thank you!
Goal is to loop through visio object and get the hierarchy.
And after that i want to output result into Excel like you see.
Another observation, this is likely to get very complex very quickly, you've posted a very simple entity relationship, but in reality relationships are much more complex. For example, how should the model look when you have a one-to-one or a many-to-many or even an entity that references itself so has a one-to-many back to itself, you'll have to set recursion limits etc.
Good point. If you have more than one type of relationship it will be caught in first loop through relationships and simple add one more row.
Screenshot_7.png
Can you help with more details?
Yes i am trying to move Access database to visio and i was doing this manually.
Best,
Jacek
Bookmarks