help me in this problem. URGENT

[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.

 

[Al Edlund]

what are you really trying to do and how are you trying to do it? How are
you handling data access?
al

 

[Haitham Khader]

Hi there,

What I'm trying to do is to manupilate a SQL statement in Visio. Where this
sql is getting values from data tables.

kind regards,