Hello.
I have a problem with Ref tables. I store inventory of the same item in multiple locations.
So I am trying to create a "Picking" and "Put away" tabs and for my Inventory Management app where you can scan the item number and also the location to add or subtract a qty. However, when I tried to ref the item number AND location from the 2 tabs to the Current Qty tab, only the item number shows. when you click on Location to select a location, it shows item numbers. I want it to show locations for that item number.
Can anyone help with this?
LinkedIn
Twitter
