I think that the gist of what you are saying is this.
One Facility has Many Communication Table 1 records.
One Facility has Many Communication Table 2 records.
etc
One Facility has Many Communication Table 6 records.
The Key field of Facility is Facility Code.
If you change the value of the facility code for a single Facility (or for several), all the related child tables record will be orphaned as they will still have the old facility code.
However, since you know what the old code was and what the new code was, you will be be able to go to each of the 6 tables and either use grid edit or else use the feature on the old report style to "Find and Replace". It is not difficult to do but you need to be in a calm quiet environment and methodically keep track of these mass updates that you are doing as you work though each of the six child tables and for however many Facilities need to have their code corrected. It's also something you probably want to do after hours because it will confuse regular users while you are making these changes.
I suggest that you Copy the Communications App as a safety net before you do that to preserve the data "just in case". It does not cost anything to copy an App so you may as well take a couple of clicks and do it.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
