Field change in connected table triggers field change in local table's corresponding record - possible?

I have an app that uses connected tables and regular tables. My records are "products" in this situation.  When work is done on a product, my vendor updates the status for that record/product to "c...