Hi @Peter,
I appreciate your input.
I do need immediate updates.
The challenge with rules is that the parent table doesn’t “see” the child table, since the connection is from the child to the parent (many child connections to one parent). So I can’t set a rule from the parent table to update the child record when the parent record is changed.
And the child doesn’t know that the connected record was updated, so I can’t set a rule from the child side.
And validation rules in a form don’t allow you to access connected records from the child table side.