Ah right, I am trying to get it to look straight at the contents of the column within the master recordset / DB table rather than some session or URL variable.
I was assuming that if I ordered the code so that the master recordset came first, followed by any child recordsets, I could take the values in the promo column and join it to the unique ID of the promotional content table.
Is it not possible to get it to look straight at the contents of a table? Is that what I am doing wrong? I've tried to build this manually, and I must admit, it has taken quite a while to get where I am just for it to not work properly, and I assumed that Data Assist and other tools from Data Bridge would enable me to achieve this quicker and successfully.