How can i calculate some kind of Investory


i want to have some kind of warehouse management.

i have a table with products.
the products have an inventory.

in another table i have a relationship between them and i wanna reduce inventory with 1, if i give our chance a datefield.

it’s this possible?

greetings Pit