I can't seem to figure out how to resolve my issue despite looking at many sources. It appears Access does not inherently have the ability to do this, but I am hoping the experts may have a workaround. Any assistance is greatly appreciated.
Table A:
Location 1 Location 2 Item ID Item Name Shelf 1 Shelf 2 123 Widget 1 456 Widget 2 Shelf 3 789 Widget 3
Table B:
Location Item ID Item Name Qty Shelf 1 123 Widget 1 5 Shelf 2 123 Widget 1 2 Shelf 3 789 Widget 3 10