Change One Field Value When Related Table Field Value Changes
I have a table called Company and one of the fields within Company is CompStatus.
I have a table called Contacts and one of the fields within Contacts is ContStatus. The status value for each of these fields derive from their respective value lists. They are set by the user.
If the CompStatus is changed by the user to "Inactive" I would like all of the related Contacts ContStatus to change to "Inactive" as well. Where would I go about making this happen? Company and Contacts are displayed in a number of places throughout the database. Is there something I could do at the table field level?