QQ: How can I get a table to update a column value from another table?
In my app, users can complete a form to save [Odometer] readings for a vehicle to [Table 1], but it pulls the current reading from [Table 2] as a suggested value for the user as a reference.
Table 1 and 2 do need to be kept separate.
I am trying to get [Table 2] to automatically update the [Odometer] value for a specific vehicle when the user saves the form to create a new record in [Table 1], pulling the most recent entry. I can do it with an action, but there is already an action on save, so is there a way to chain, or combine actions on form save?
