Multiple Google maps locations, column range, table relations

[ardi_kule]

Hi

This is my setup:

I have a table of products

And I also have a table of restaurants where these products can be consumed or purchased. All of the restaurants have google location coordinates.

Each hotel or restaurant serves a number of products, e.g. honey, butter, cheese, etc. Therefore it cannot be only one single product per restaurant.

Now, when I access product detailed view, I want to show a link to a map of all the restaurants where this specific product is served. It usually is more than one. This link should say “Where to eat”.

How do I approach this problem?

If you know any expressions, pleas show me how to add them, because I am still a begginer.

Thank you.