We've got 5000 stores. Each store is assigned to a region with 10-12 other stores. The problem is that stores are constantly being reassigned and moved to different regions.
For reporting purposes, we'd like to be able to tell which region a particular store was in at a certain point in time. For example, Store 00085 might be in Region R0042 now, but what region was it in on May 5th 2004?
Whats the simplest way to track this sort of thing? I'm guessing a database with store number and start date and end dates, but I'm not sure how this would be keyed.
For reporting purposes, we'd like to be able to tell which region a particular store was in at a certain point in time. For example, Store 00085 might be in Region R0042 now, but what region was it in on May 5th 2004?
Whats the simplest way to track this sort of thing? I'm guessing a database with store number and start date and end dates, but I'm not sure how this would be keyed.
![[ponder]](/data/assets/smilies/ponder.gif "[ponder] [ponder]")