Hi Guys,
Can you help me please.

I have 3 tables. Elements, ResponsiblePeeps, ElementsRespLookup
Elements Tabel Layout:
ElementID Int, identity
ElementDesc Varchar(50)

ResponsiblePeeps Table Layout:
ResponsiblePeepsId Int, Identity
ResponsibleName Varchar(50)

ElementsRespLookup Table Layout:
ElementID Int
ResponsiblePeepsId Int

I need to show the ElementDesc field in the first column of a grid and then go to the ElementsRespLookup and get the ResponsiblePeepsId that are linked to the ElementID and then display the ResponsibleName from the ResponsiblePeeps Table in the next column.

For each row of element data I have in a table there can be 1 or more responsible persons for that element.
In each datarow I need to show the element and all the responsible people in the adjacent cell. IE.

+-----------------------------------+----------------------------------+
|.......Element................................|.. ............Responsible...................|
+-----------------------------------+----------------------------------+
|Development and execution.............|..........Jason Davis.......................|
|................................................. |...........Steve Wilson.....................|
|................................................. |...........Jake Smith........................|
+-----------------------------------+----------------------------------+
|Logistics......................................|. ..........Andrew Fuller....................|
+-----------------------------------+----------------------------------+

How can I do that. I can pull out the responsible people if there is only 1 but I do not know how to put 2 or more in the same cell.

I hope that makes sense. Thanks for your help I really appreciate it.

Best Regards,

Steve.