I am building some reports to show data similar to what you can see at :
As the link show there is one picture for each product and a list of dimensions for each product.
I have 2 tables-One having all the dimensions for one specific product, another one having the picture to use for each product. I do get all the information, but I am having problems to generate a report showing the only the picture one time per product.
Can somebody give me a hint on how I should retrieve the data to produce such reports?
Thanks in advance
As the link show there is one picture for each product and a list of dimensions for each product.
I have 2 tables-One having all the dimensions for one specific product, another one having the picture to use for each product. I do get all the information, but I am having problems to generate a report showing the only the picture one time per product.
Can somebody give me a hint on how I should retrieve the data to produce such reports?
Thanks in advance