i found some similar cases in other topics but i’m not sure they are my exact case, so…
i have a main table full of records that i need to update, but not just editing them.
So i have create a “twin” table with most of the same columns but this time the table is empty; this one is suited to create new event on every change with a timestamp, so i can keep track of all the changes and the history too.
Now, i need to update the main table with the newest values of the second one.
I have created an action in the first table with all the field i need to update, with a lookup(maxrow(data…) in the second table
Everything is fine, ecxept that i have to go into the first table and press the action.
I would like to update automatically when i create a new record in the second table.