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

Wow. Success! What a great trick. 

To wrap up the original question - I created the relationship (now to a formula key field) and summary as described. Then used my table's status field to reference the summary field. 

Thank you very much for the help. This was a huge stumbling block to automation.