Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
6 years ago

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 throug...
Relationships
AshleyAsante's avatar
AshleyAsante
Qrew Cadet
6 years ago
Thanks for your help so far,


I got the first part of the solution.
I created Min Rec ID and Max Rec ID summary fields.

But I'm not sure how you were able to then able to create (Min Rec ID Shipped Revenue, Max Rec ID Shipped Revenue, etc).

Could you send me a screenshot of the field properties for one of those?

------------------------------
Ashley Asante
------------------------------
EverettPatterso's avatar
EverettPatterso
Qrew Captain
6 years ago
Just change the Field to summarize from Related Parent to Warehouse Revenue and leave the function on Minimum



------------------------------
Everett Patterson
------------------------------