UE recipient recordset field = index to second recordset?
Hi - I'm using Databridge 1.1.3....
I have a form that sends emails using the Universal Email behaviour. The page with the form on it has 2 record sets. Recordset "A" is the recipient list. In that recordset I am also getting the UserID for each record.
I'm struggling with figuring out how to pass that UserID to a second recordset as the index, so I can call the fields from the second recordset in the body of my email. The second recordset query is complex (for me anyway) and I don't think I'm able to join it to the recordset "A", hence the 2 RSs.
I've got my page sending emails to the recipient list no problem. I'm using the solutions found on http://www.webassist.com/forums/posts.php?id=17869 and I think I understand I can pass the UserID column from RS "A" to act as index for "B" using WHERE UserID = ($RecipArray[$RecipIndex]["[UserID]"]), but I'm having troubles at that point. I've been putting RS "B" in the email template file at the top, and have also tried putting the query in the actual body of the email, but no worky.
Also, about looping - does the UE behaviour loop through the email template for each recipient?
Has anyone tried something like this and am I at least in the right direction? Or is there another way to skin this cat so to speak?
Many thanks for reading this!