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
Cobalt58_9's avatar
Cobalt58_9
Frequent Visitor
1 year ago

I have not used lat/long, simply the city, state/province, and country names. And I do have them broken out by each league, sometimes up to four different leagues, and then tried using an "order" column to keep them organized, but that didn't seem to work.

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.