Forum Discussion
Labels on Maps
Hey thank you, that does work.
But still wondering how to do it with two tables, because my client addresses has a bunch of other information that my clinic locations doesn't have, and also just wondering how to do it with two tables to learn another way.
Appreciate your knowledge!
Hi there
If I understand correctly, can you not create 2 maps with different requirements?
So that each map is representative of what you are trying to achieve?
I want one map that shows my clients (a few thousand of them), and also shows my several clinic loations in another color. I have a mySQL database I'm pulling the client info from, and a separate small table with my clinic locations. I don't want to have to edit the client table to add my clinic locations each time, and also they contain different information besides the address.
Hi there what I can suggest is in your client data, to add a Custom Colum called "Classification" and put in there "Client"
Next for your Clinic Locations data add a Custom Colum called "Classification" and put in there "Clinic"
Then Append the data in the Query Editor to your Clients data (so you will append from your Clinic data). In doing so you can have all your data in one table. And then you can use the Classification on the map to show them as different colours.