How do i link a database table to a visio document

[Matt Holmes]

Hi,

I am attempting to produce a visio diagram using data from 2 tables in a
database one which contains the items and one which contains the links. The
diagram i want to produce is a dependancy tree of all the items using the
links in the links table. I am able to connect it to the database but i
cannot get it to produce anything other than 1 master for each item in the
items table with no links between them. I have tried to use the database
wizard but cannot find how to get it to work.

The 2 table structures are as follows:

Item table
id, type, name, description

Links table
nid, did

The relationships on the tables are set up so that nid and did in the links
table relate to id's in the items table.

Any ideas would be appreciated

Thanks
Matt

 

[David P (Visio MVP)]

The DB Wizard is not designd to link shapes unfortunately.
So, a coding solution is the best way forward ... there is a Visio SDK with
a similar example for flowcharts. Are you a coder?

 

[Yan-Hong Huang[MSFT]]

Hi Matt,

David is right. Vision SDK can be downloaded at
http://www.microsoft.com/downloads/details.aspx?FamilyID=557120BD-B0BB-46E7-
936A-B8539898D44D&displaylang=en

The Microsoft Office Visio 2003 SDK provides developers with tools,
samples, and documentation to support custom solution development on the
Visio 2003 platform using Microsoft Visual Studio 6.0 and Microsoft Visual
Studio .NET 2003 development tools. You may refer to its samples to
accomplish it.

If there is any question when you are developing it, please feel free to
post here and we are glad to work with you on it.

Thanks very much.

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! ¨C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
http://msdn.microsoft.com/subscriptions/managednewsgroups/

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Matt Holmes]

Thanks for the help Yanhong and David.

I am a coder so i will grab the sdk now and do it that way.

Thanks again
Matt