Hi Lance,

In the GetLinkedValue formula, is "Trenton" the name of the calculated column that displays the WA quantity?

I presume that both of these views are in a Workspace. If so, try accessing the File / Set Workspace Recalc Order area an ensure that the Trenton Qtys view is set to calculate first, so that the contents of that inquiry are determined before the Items to Order inquiry.

Ensure that your Trenton Qtys inquiry has a primary sort by Item #, so that the lookup works. 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.

Try without the trailing ,0 as the 4th parameter. The required usage of this is to have a positive number (for the next item) or negative number (for the previous item) - not 0 - in case the exact item # is not found. This is not the desired results for your inquiry.

The syntax of your formula is otherwise correct, assuming that the "Item #" field appears in both views and have the same column title.