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.
  1. Create a View showing the information you want from the Item Location Master.
  2. Create another View that shows all your inventory items (perhaps just item number and description).
  3. Define a link from the Item number in the inventory list to the location View.
  4. 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.


Attachments
IC ItemList.zip (87 downloads)
Description: GridView Workspace to look up item quantity information in the item location file.


_________________________
Andrew Bates