recordset1 is an accessory table
recordset2 is a brand table

Repeating region displays recordset1 and contains an index to the brand table
and I want to display the correct brand name based on the index in recordset1