When the form is saved I want to change a record from other table

[ingalsaac76]

Hello, I have 2 tables
“statistics” with these columns:
product
last purchase
last quantity

“order_detail” with these columns:
order
product
date
quantity

I want that for each record on the table order_detail make an update for the product on the statistics table updating the date and quantity.

How can I do this?

thank you for your help