Parent Points on Map

[Cobalt58_9]

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 map will show the minor league locations as well. 

This has to be possible right? I think I'm having the most trouble figuring out how to setup data amd relationships. What do you think? Thanks in advance.

[pborah]

@Cobalt58_9 , what do you have for geo data either pro teams or minor leagues or both? You can create two related tables one containing pro teams and the other containing minor leagues with primary and foreign keys.

[Cobalt58_9]

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]

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]

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

[v-yajiewan-msft]

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.