Forum Discussion
Parent Points on Map
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_91 year agoFrequent Visitor
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.
- pborah1 year agoSolution Sage
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_91 year agoFrequent Visitor
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