Connecting a database to my drawing in Visio

H

Haitham Khader

Hi there,

I have a SQL database with two tables related to each other by a specific
colomn. This colomn in the main table is unique and in the second table is
not (i.e. it's repeating in the SUb table). Each item in the main table has
many items in the sub table.

How can I let Visio displays all items in the second table? What I did makes
Visio displays the first item value in the second table only and neglects the
other values.
For example:
Item ID in the first table = 1
in the sub table:
ID | Value
=================
1 | x
1 | y
1 | z

What I have is value x only and is not displaying y and z. How can I let
visio displays y and z??

Help me very soon pleas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top