1 2 Previous Next 15 Replies Latest reply on May 9, 2012 8:58 AM by philmodjunk

    Change One Field Value When Related Table Field Value Changes

    Tucker

      Title

      Change One Field Value When Related Table Field Value Changes

      Post

       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?

        1 2 Previous Next