Can anyone help please?

Dear developers…I will give a brief description of what I am trying to accomplish and I hope someone will have the know-how to help me.

I am building a website which has 800 products.
I have created an “index” page which populates the logos of the 60 or so brands from a database called “Brands Collection”, which make up the 800 products. The logos are displayed in a gallery.
In the Brands Collections database, I have 3 fields. Collection Image, Collection Name, Link Reference.

The “Link Reference” field allows that individual “row” or “item” to connect to another database which is used to display content on a dynamic page and that database is supposed to list all the products for that specific brand.

below is an image of the logos. When Smok (left middle) is clicked, it lands on a dynamic page and is supposed to list all the products for that brand.

The linked database is named “Brands Dynamic”. see below please

Now on to the issue/question:

The dynamic page is connected to the database which has the following fields:

As you can see, this is the database for the Dynamic page and once the logo is clicked on the “index” page with the logos, the specific logo which is clicked opens the appropriate “Brand Name” on the dynamic page. It populates all the fields and loads the images from the “Media Gallery” for that specific brand into the Wix Pro Gallery. The dynamic page loads the correct page for Smok when Smok is selected from the “Index” page above.

So far so good.

However, when the dynamic page displays the media gallery from the “Brands Dynamic” database, it only loads the images and names.

How can I set it up so that when the dynamic page is populated with the correct Brand and all the product images for that brand are loaded into the gallery, clicking an image for one of the products leads the visitor to the “Product Page”.

Since the “Media Gallery” is not linked to the “Stores/Products” Collection (I don’t know if this can be done or not), clicking the image only opens it in expanded mode instead of going to the Product Page.

This is where I need help or an alternative/elegant solution.

I hope I have explained this sufficiently.

Thank you so very much
Shane

I do think there may be a way to display the content for the dynamic page for the Brand through the “Stores/Products” Collection, filtering it according to the brand selected from the “index” page (the logo page) through code, but I don’t have the slightest idea what that code would look like.

Also, is there any way to link a “Product Widget” or “Product Gallery” to a dataset? The idea being that if the Product Gallery/Widget can be linked to the database for the dynamic page, it would display only products (clickable images) for that brand and I could bypass entirely trying to make individual media gallery images lead to the Product Page.

Again, any help will be appreciated. thank you!