Also, if there are multiple rows in the Trenton Qtys inquiry for each item (ie one for each location), that may confuse the lookup. You might have to consolidate the Trenton Qtys so that there is only one row per item number.
How would I do this? There are multiple rows for each item. What do I do to consolidate that?
Previous Topic
Index
