images loop not displaying
Hello, ok my website is build up using webassist plugins (but I've also tried on single page) I have a series of client portfolios that have a title, short description and a set of photos) so the client are in a repeat region since these can be added to by Admin. then their photos are in a repeat region. but I have tried many different approaches and I cannot get the correct photos to loop for each individual client. The beauty of plugins is that I can reference a URL parameter but that don't work. I tried to do a Join, Left Join etc (but must have that set up wrong. The fields are:
PORTFOLIO table
PortfolioID
PortfolioTitle
PortfolioTXT
PortfolioImgID
IIMAGE table
ImagesID
ImagesFile
ImagesClientID
How would I define recordset so that I can repeat the portfolio table to display all records then also do another repeat (sons repeat inside a repeat) so that I can display all images that relate to each portfolio.
Would I need 1 or 2 recordsets and would they both be at the beginning of the page or one recordset defined inside the first loop?
Kind regards to anyone that can help :)