I am joining two tables.

Customer table has a one to many relationship with Inventory table

I just want to pull back the customer table rows with the most recent row on the inventory table for that customer. There is a date on the inventory table so is it possible to tell crystal reports to just pull back the customer row along with the most recent row on the inventory table?

Can you explain to me exactly how this will work?

Yeah I understand that but this will just bring back one row as being the max for every report. I want the max date per customer. So if there are ten customers on the report I want the max date for each of their inventory items, so ten dates, not one max date for the whole report.

Edited by colman1212 - 19 Oct 2010 at 5:09am

Thanks for all your help.That doesnt really makes sense to me though. What do you mean by 'Other row'?