Hi guys,

I ended up setting up the database locally in order to test and run the pages I'm creating. (Apparently Yahoo servers don't allow remote access to the database <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> )

Anyway - I have two simple tables at the moment - like this:

ID Name Description Pic - this table uses the ID as a unique identifier for pulling info from other tables


ID ProdNo Size Price - this table lists the various product numbers, sizes and prices of the products in the first table. With the ID number being the part that identifies what product we're talking about in this table. The ProdNo is a "unique" field for this table so it has a unique identifier.


Now - the fun is - I am trying to figure out how, in DWMX 2004, to create a table that will list the Name, Description and Image of a product once - and then list all available product numbers, sizes and prices for that particular product.

So far I have managed to setup a repeat region which successfully shows the products Name, Description (I didn't ask for picture yet) and then for the Product Number, Size and Price it only is listing the first record from the 2nd table - how do I get it to list any records from the 2nd table that have the same ID as from the first table ?

Thanks,
Tracy

Ok - I figured out how to setup the relationship between the two tables in phpMyAdmin and then got a free extension from Tom Muck to keep the Name and Description parts from duplicating for each different size and price option.