I have three tables used for inventory tracking, which I need to auto-populate whenever the devices are shipped. All three of these tables relate to the main table we track all the items shipped from inventory(named RMA_Tracker). I'm using the field Mac_Address to determine if the device is shipped, as it is a totally unique entry we use to identify each device.
Now, what I'm looking for, is a querey that can update two fields on the inventory tracker tables (6921, 7942, ect), based off if the MAC appears in both the RMA_Tracker and the inventory tables.
Basically, IF the MAC appears in both tables, then add the date and ID from the RMA_Tracker table to the inventory tracker. (Black being the MAC, the red being what needs to update on the inventory tracker sheet)
Does that make any sense?