Hello all, I’m new to the community and have been finding so many valuable resources here - thank you!
I did some research on this question but wasn’t able to quite find the solution.
Here is the basic layout of the two tables in question:
RIGS table // Shows all our available inventory
Rig 01
Rig 02
Rig 03
etc
EVENTS table // Shows event details including which pieces of Inventory are assigned to which Event
Event 1 - Rig 01
Event 2 - Rig 02, Rig 03
etc
Objective: As Inventory is assigned in the EVENTS table, I want to remove the assigned Inventory from the RIGS table dynamically. I can make this happen per field, however it doesn’t translate to all records globally.
Thank you so much for your help in advance!
Joanna