tutorial "Displaying Nested Recordsets With Data Bridge"
This was a great tutorial.
I want to apply what I learned in this to a PowerStore store (4.53) I'm working on. I want to create a "Related items" or "If you like this you may like these" section on the product details page.
In the tutorial it only uses two tables: menu_category and menu_items
In PowerStore (4.5.3) would I need to use three tables?
- ps4_categories -- to match with the same category as the product detail page
- ps4_productcategories -- to match the productID with the categoryID
- ps4_products -- to display the data from the above matches
What would the recordset look like to accomplish this?