Getting Data from the Max ID Record in a Child Table

I'm working on a Parent table of Projections.
Each Record represents a month 1-12.
The fields in the record are Date, Warehouse Revenue, and Shipped Revenue.


When projections are changed throughout the month, a record is created in a Snapshot table, to see changes overtime. (Using Automations to Copy the Warehouse Revenue and Shipped Revenue.

I used summary fields and report links to show the First Reported Forecast (using a report link to the minimum record ID) and Latest Reported Forecast (using a report link to the maximum record ID) on the parent table, but is there a way to actually get the Warehouse Revenue and Shipped Revenue from the First Reported Forecast and the Latest Reported Forecast?

Using the report links on the table only show me the record IDs, and not the actual values.


Thanks for any help you can provide.

------------------------------
Ashley Asante
------------------------------