Forum Discussion

AshleyAsante's avatar
AshleyAsante
Qrew Cadet
5 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
EverettPatterso's avatar
EverettPatterso
Qrew Captain
Is this what you are wanting to accomplish? In the summary field options, you can change the dropdown "Choose a field from the "Projections" table" and select the Revenue field you want. You can make additional summary fields for minimum and maximum then change the dropdowns to the appropriate revenue. 







------------------------------
Everett Patterson
------------------------------
AshleyAsante's avatar
AshleyAsante
Qrew Cadet
5 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
    5 years ago
    Just change the Field to summarize from Related Parent to Warehouse Revenue and leave the function on Minimum



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