Relate Multiple Locations in a table to a Project Record in another table?

[VictorSunrise]

I have a table with project names and it contains a column for location, which is pulled from another table.  I'd like to be able to select multple locations for a project and have them displayed on a map. 

Here is a sample from the Project Table:

and Locations Table:

I also tried to break up the locations into multiple columns:

Using a one-to-one project to location works beautifully, but trying to use multiple locations doesn't seem to work.  

Has anyone tried doing something like this, or is this a limitation?

[Zang_Mi · Accepted solution]

Hello,

Since one project may have multiple locations which are stored in a string separated by comma, the best solution would be to transform the data table (with Advanced Editor) breaking up the data entry into x rows, one for each location related to the same project. 

Project Name	Location
Project A	Location 1
Project A	Location 2
Project A	Location 3