>When I place it in the rule it updates the second I change just one field. I'd like to update it when the tableupdate executes. I'd write code at the form level but this will eventually become a SQL Server app and need to get all the rules and triggers in the DBC.

Are you saying that you are using buffered views but when you change one field on your form that the record rule validation gets called?