Repeating recordset alerts me to choose recordset and statement to show if captions match

When I attempt to use the dreamweaver server behaviour to add a repeating region I get an alert to create a recordset.
I attempted to highlight the content I want to repeat, I attempted to click on the recordset in the panel that I want to repeat and I get the same message.
I ended up copying the repeat code from another page and changing the recordset name to match but would like to know the proper way.

Now that I have my repeating region in the sidebar of me detail page I would like to show all the records that contain the same caption as the current record.

Additional details in PM.

Was the recordset showing in the server behaviors panel? Maybe you had selected the regular repeat region and not the MySQLi Repeat Region?

You should be able to add a parameter to the recordset to filter it to show the records with the same caption by using the getColumnVal() from the recordset above.