I am joining the works table to the workitem table by wknumber. I am joining the wkitem table to the invent table by partnum.
I would like the record from the invent table to be the newest record so they can see the date the part was last ordered. How do I do this in Crystal?
I am grouping on works.wknumber, works.wcode,dateshiped,part
Thanks
Jim