Filtering Products by another collection results

Hi,
This is what I need to achieve. Please, can someone point me in the right direction?

I have a page with two repeaters on it. The first repeater is linked to a collection I configured that displays the results based from the dropdown boxes.

So if i select ducati, monster 1990 i will get back all the collections that relate to that motorbike.

I then want to click on the “Go To Collection” button which will filter the second repeater which is set up to get all the store products. Im struggling to figure out a way to link the first collection with the make and model etc with the store’s products. It would help if i could add fields to the store products but I can’t :frowning:

Has anyone got any pointers?

Have a read here.
https://support.wix.com/en/article/displaying-content-from-multiple-database-collections-using-reference-fields-4034931

Thanks, i have already tried this and i dont know which field it references as it doenst tell me and i get no results back no matter what i type in there :frowning:

my reference field doesnt return any data.

So interestingly if you deselect mulitple products it allows you to add one product! this isnt helpfull for me though.