>recordset1 which along with other information contains the index to
corresponding recordset2

Hard to without seeing the bigger picture, but if the two recordsets are
related can't you just combine them into a single recordset query?