Find based on aggregates of related records
I wish to run a find for several criteria of customers first, then I wish to weed out all the customers who have a work order AND who, on the last day they had a work order, at least one of the work orders were larger than $300.
I've scratched my head about this for a while but need help. I got the first find, just need the weeding out part. (Thanks in advance)
I am in a customer file (one record for each customer) which is related to a Work order file (possibly many records for each customer) via the customer number..