Hi Richard,
Okay, let me understand. Are you:
(a) entering opponents from the Teams table using the Select Opponent field and inheriting the location from there, or
(b) typing the opponent into the Opponent field, then adding a location from the Game Locations table using the Select Location from Game Locations field?
Ass-u-me-ing it is (b), I dug into this a bit and here’s the deal … the location from the locations DB is stored in the Games table as the primary key (the ID if you will) for the location record in that table. That’s sort of the normal and natural way to do it, but that key is different on every system. For the exact same schedule, the key on one WP instance will be different than the key on another WP instance. This is an issue I uncovered in building a bespoke app for another customer. I jotted it down as something I need to address in the next upgrade. The same issue will occur with the Teams table in scenario (a).
So stay tuned, I’m thinking about it.
-Mark