I have a client that is looking for a report that would flag When a new location has been added to a previously termed provider (example PCS 82798 and location 26 (both 26 and 27 will need to be deleted/termed)).
Here is a little print screen of my data. We would probably need to base it on the PCSP_id1 (That is the Unique Key). The location number is pcsp_id2. I don't think we would need to do anything with pcsp_id3.