Hi there,
I am trying to create a link between my “Handover” table (which has a unique ID for each transaction of multiple items) and individual “Inventory” Items (which have been coded uniquely as well). What I would like to have happen is that as soon as one or multiple items are handed over, it adjusts the value of the specific “Inventory” items.
The Primary Columns are different for each table. Can anyone help with this?