June 23, 200520 yr I don't know where to put this but I'm assuming I need a calcualted field. I need to show on a report the latest quote amount for a job. There might be many quotes for one job, some which are declined and some which are accepted. I was thinking that maybe I need to use the max function to find which is the latest date and then get the related quote amount but I'm not sure how to go about it. thanks
June 23, 200520 yr Either sort the relationship in ascending date order and use Last(rel::quote) or sort it in descending order and use rel::quote.
Create an account or sign in to comment