How to create a nested repeat region
I need to create a nested repeat region using 2 recordsets from 2 tables.
Table 1 contains all categories
Table 2 contains all products (with cat_id as foreign key).
I need to list all products in every category:
- product1, product2, product3
- product5, products6, etc... etc...
I tried to move the code of the 2nd recordset inside the code of the first one and adding the GET parameter, but I can't get any product listed. Only the category list.
What is the magic once the two recordsets are created?