Recordset A has user_id as key. Recordsets B & C contain a field with that same user_id (although it is not the key in those cases)
On the web page:
I have a repeat region that lists the records in recordset A.
Within this repeat region (maybe this a second repeat region?), I'd like to display a field from recordset B, using user_id as the filter AS WELL as a field from recordset C, using that same user_id as the filter again. When the matching records of B&C are run through,
It goes on to the next record in recordset A.
Any direction, pointers or help would be really appreciated. I know how to make recordsets, regions etc. but I am stuck on how to get a record in a repeating region to look up and display data from another recordset within that region.
Also, if you are an ADDT wizard and are looking for a gig let me know (hope this is ok in this forum).
I honestly can´t see such an "interactivity" between several repeat regions on one page happen without considering an AJAX based approach -- Dreamweaver´s /ADDT´s repeat regions are applied to static pages, and once the data is loaded, that´s pretty much it.
Did you have a look at e.g. the SPRY framework ?
Adobe Community Expert, Dreamweaver