Hi all I'm trying to create what I thought was a very simple Inventory database,
what I'm trying to accomplish is as follows
I have a (delivery table) for receive the delivery for example receive 20 units
I have a (usage table) for example 1 unit is used
I then have a (stock table) for total stock which should now be 19
(usage table) uses 1 more unit
Total (stock table) should now be 18
how would I go about making something like this?