RickPutnam1
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Display field of most recent child record?
This is a nice technique. Unfortunately, I found the description fairly confusing, so I'm going to restate it in a way my beginner brain understands. The following description assumes a relationship has been created between Parent and Child tables and you are on the Edit Relationship page: On the Parent side, create a Summary Field of type Maximum and relate it to the [Record ID#]*. Call it [Latest Child Id]. This field will capture the Record ID# of the most recent Child record related to a given Parent. On the Child side, create a Lookup Field that references the Parent's [Latest Child Id] (the one we just created in step 1). The name will default to [Parent - Latest Child Id]. This will be a field on each Child record referencing the Child [Record ID#] that the Parent sees as the latest one. Finally, on the Parent side, create a Summary Field of type Combined Text that references the field you want to display, say "Your Field", from the latest Child. Under the "Only summarize records where the following is true" section, set [Record ID#] equal to [Parent - Latest Child Id] (the lookup field created in step 2). This allows the Summary Field to filter out all but the last of the Child records. Call the new Summary Field [Latest Child "Your Field"]. Display the Parent's new Summary Field [Latest Child "Your Field"] on reports and forms as called for in your requirements or use cases. Note wherever I've used "Child" or "Parent" in a field name substitute the names from your tables. * [Date Modified] might be a better way to capturing the "most recent record" depending on your use case.14Views1like0Comments