Hi, I am new to Access so I'm not sure if my question is gonna be with an obvious answer. I have created two tables - "Delivery Note" and "Inventory". I am wondering if there is a way to, short of making a really complicated macro(?), update data in "Inventory" after making a new record in "Delivery Note". Like, when I make a new record (ID=3) down here in "Delivery Note" with a data of Water Barrier equals to 10, then the Current Quantity of Water Barrier down in the "Inventory" table will decrease by 10 automatically. Is that possible?
In Excel, I know how to use equations connect the value updates between cells. But here in Access, I'm not sure how to type in equations when the column is already defined as Short Text/Number, etc. since it seems we gotta make the column Calculated Field to type equations. Plus, formatting a new record seems different than formatting an existing cell. And let's for now ignore the fact that the Parts Name in the 2 pages do not fit except for Water Barrier. I will have more complicated relationships defined soon. Thanks for the help!