I have a separate database supermarkets and their suppliers. I have as well database which suppliers provide products to particular supermarket. I would like to create such a tool/solution where after clicking on the point on map (which is supermarket) I will receive a message with their suppliers. It could be short message and "flash" of the suppliers.
I am new in gis, does anyone have an idea how to solve it?