Jon23
Mega Sage

Hi,

Yes, you should create the business rule or trigger a flow on the primary table update.

Not knowing the exact details I would lean towards a flow (no-code/low code) solution.