Plotting design lines from different revisions

In report design, I'm trying to plot design line information into a log, for example strength parameters with depth.

I have the data in a table with keys: PointID, ItemKey and Depth, where ItemKey is a revision number and is stored in a parent table with keys: PointID and ItemKey.

How do I only display information in the log for a particular revision, and if possible for the latest revision in each instance?