I have a master/primary table tracking the opening of various retail sites. The order of the records shifts based on schedule changes for site opening dates. I have additional tables that for the same sites, and would like to have those records shift ordering when the primary table changes.
How can link the tables to change ordering at the same time?