Hello Barb,
There's another way to accomplish the same task which might be easier and run more quickly if you have a large number of items.
- Create a View showing the information you want from the Item Location Master.
- Create another View that shows all your inventory items (perhaps just item number and description).
- Define a link from the Item number in the inventory list to the location View.
- Save the two Views as a workspace.
Now, to see the item quantity information for a specific item, just click on the item number in your item list. To see the quantities for multiple items, select them using shift-click or ctrl-click and double click to generate the link.
The lookup is virtually instantaneous.
I've attached a ZIP of the workspace I've described.