I need to show all of the activates in a certain area, I have the following data
But the problem is the the A organization has 8 projects, and for H on 3 projects as shown, and so on.
The implemented projects sometimes varies in location and this is easy to map but sometimes they are in the same location such as ( capacity buildings, Institutional Development, Customer relations,….)
I am now confused if I should create one point for the “A” organization for example and then link it to a table of the projects because this is the right behavior in creating the database, but the now I care more about viewing data on a PDF map. So what can be done here to show that data in an effective method and managing the database correctly.