AnsweredAssumed Answered

What is the best practice to map one to many relationship?

Question asked by ahmadabusaleh on Feb 27, 2016
Latest reply on Feb 14, 2017 by ahmadabusaleh

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.