Forum Discussion

Cobalt58_9's avatar
Cobalt58_9
Frequent Visitor
1 year ago

Parent Points on Map

Hi everyone, having trouble figuring this out, and hope I explain it correctly.   I want to show affiliates on a map, specifically for sports leagues. Essentially, when you select the pro team, the...
Need Help
pborah's avatar
pborah
Solution Sage
1 year ago

Thanks Cobalt58_9 , using lat/long will probably be more precise especially if multiple pro or minor teams belong to the same city.

 

You mean you have both pro and minor teams in the same table? If so, it will difficult and complicated showing them on a map in that data structure.

Cobalt58_9's avatar
Cobalt58_9
Frequent Visitor
1 year ago

I do have a master list with all of them together, but also have them broken out.

 

For example here is my hockey book:

^NHL Team

 

^AHL Team

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Cobalt58_9 , hello pborah, thank you for your prompt reply!

     You could create a relationship between two tables as shown below:

    Then select the City column from both tables:

     

    Result for your reference(Drill down or drill up to get the parent and child city):

    Best regards,

    Joyce

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.