We have situations where we receive checks in payment and it’s a challenge to chase down what it’s in payment of. I have a form that provides parameters to a query for looking up the record by order number, person ordering, and organization associated with person ordering. I’d also like to took it up by order total, but order total is a calculated value in a form object.
What’s the best approach here? Do I need to save the calculated value using the form object’s AfterUpdate to the underlying orders table?
E