I'd like to create a visio drawing based on a directed graph that I have in a database.

[Ben Donley]

I'm just starting out on a project. I'd like to create a visio drawing
based on a directed graph that I have in a database.

I have a list of entities in my database, with (among other things)
names and ids.

I have a list of relationships in my database, with (among other
things) relationship-id, to-id, and from-id.

It sounds like I could solve this with VBA by creating shapes for all
the entities, then creating connections and gluing them to entities
accordingly. Is that the one true and only way?

For some reason I'm averse to that route, so I tried to create stencil
shapes for my entities and relationships (connectors) but it seems that
the "Dynamic connector" object does not have properties that would let
me link it to and from the primary keys of another table.

Am I barking up the wrong tree? Do I have to iterate through my
entities and relationships using VBA, or are there built in functions
to accomplish my goal? The connection-oriented documentation that I've
found assumes an all-VBA solution, and the database-oriented
documentation ignores connectors (as far as I can tell).

Pointers to docs or any other help would be greatly appreciated.

Ben Donley

 

[Al Edlund]

you're correct that the code will have to be created, it's not a standard
function to auto draw connections.
al