General information
Title:
Getting newest record from third joined table
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only