AnsweredAssumed Answered

Having trouble creating simple inventory

Question asked by alexp on Sep 19, 2017
Latest reply on Sep 20, 2017 by PeterDoern

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?

Outcomes