How can I cause an update to the key column to trickle down to all of the other tables that reference it?

I have a master table (cols: “Building Code” (PK), “Building Location”) that has many other tables referencing it. There are scenarios where the users will need to update the Building Code, and I was wondering how I’d be able to reflect that change across all of the tables that reference it.


See my answer here:

1 Like

Thanks Marc!