Forums
This topic is locked
Dreamweaver MX recordset
Posted 10 Aug 2003 16:05:43
1
has voted
10 Aug 2003 16:05:43 Rob Rocket posted:
I have the following tables:PROD
prodid | prodname | proddesc
1815 | Hat | Patriotic Hat....
COLORS
prodid | color
1815 | Red
1815 | White
1815 | Blue
When I join these tables in my recordset my result is
RECORDSET
prodid | prodname | proddesc | prodid | color
1815 | Hat | Patriotic Hat....| 1815 | Red
1815 | Hat | Patriotic Hat....| 1815 | White
1815 | Hat | Patriotic Hat....| 1815 | Blue
How do I get this to display in DW as follows:
1815 - Hat
Patriotic Hat
Red, White, Blue
I don't want this displayed 3 times, once for each color, but rather as the
one item with the 3 possible colors listed. Thanks.