Latest quote details

[Sari]

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

[-Queue-]

Either sort the relationship in ascending date order and use Last(rel::quote) or sort it in descending order and use rel::quote.

[Sari]

Thanks, I've just got back to this (!) and I'll give it a try.