I have 2 recordsets Recordset1 & Recordset2
I am wanting to create a repeat region of the Recordset1 but also have a colum that is linked to Recordset2
Recordset1 is transaction details based on url=MemberID
Recordset2 is member details based on the column MemberID in Recordset1
when i try to do this, i get the first record in the database for Recordset2 column on all the listing in the table.
Can I make Recordset2 dependent on Value of Row for Recordset1?