Recordset only returns one row
I have two pages - a lube navbar page that links to a lube info page. These use a URL parameter to show results. Need to have a toggle button on the info page that shows all the products associated with that lube.
Trying to use the 'lube' URL Parameter to show the product list.
Using three tables: lubetype, prod (products) and prodtype (this one ties in the first two with foreign keys)
My recordset uses the 'lubetype' table and INNER JOINs both 'prod' and 'prodtype' tables. The filter uses: lubetype table ID = prodtype table ID.
The results are correct, but can't get the region to repeat. I've tried using different tables as the main recordset table and tying in the others. Also tried moving the repeat region around to see if that's the issue. No success so far. I've tested the recordset in the dialog box and multiple results show.
I feel like I should be able to use the URL parameter from one table to show data from another table using inner joins, but it also could be a simple repeat region problem. Do I need to pass a product ID in the URL to show a product list? Can filtering use columns from separate tables?
As you can tell, I'm all over the place on a solution.