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?