So I escaped the necessity of the re-write for now, although I know I won’t escape it forever. But here’s how I handled it.
I created a new table duplicating the necessary fields. Additionally, for this table, I added 3 new fields, “area”, “date” and “facility” (all 5 MRI areas, all 5 MRI...