Linking a handover (Multiple Items) to Inventory Items

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?

Hi @Jarryd_Williams would you mind sharing the schema of your two tables that you want to link together? A picture would help the community see how you have the links set up.