I have a query that sums the stock available for sale. On the sale datasheet when the user selects the product for sale, I want the available stock to show. How do I get it to show? I tried referencing the field in the query but that didn't work.

Thanks