AnsweredAssumed Answered

Find based on aggregates of  related records

Question asked by HB on Jul 28, 2011
Latest reply on Jul 28, 2011 by philmodjunk

Title

Find based on aggregates of  related records

Post

Hi

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..

Outcomes