Try:
SELECT * FROM items INNER JOIN Options ON items.itemOptionGroup = Options.itemOptionGroup AND items.itemOptionGroup = SETUPAPARAMETER
Since you are using a repeat region, you are going to have to nest this recordset inside the repeat region so that you can have a unique recordeset for each row, since each will have it's own results.
You might want to start by getting it working on the details page. Then once it is come back and do the results. It will be similar, but more complex with manually moving recordsets and setting parameters manually.
Did this help? Tips are appreciated...
