Forum Discussion

BrianDunk's avatar
BrianDunk
Qrew Cadet
23 days ago

Populating Child Table Date Field to Parent Record

I have a Parent/Child table relationship for two tables.   On the Child table there is a date field that I would like to populate up to the Parent table for use on every new child record in the Child...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
23 days ago

Is it a Date field from the first child created that you want to summarize up to the Parent? 

If so you can go to the Relationship and make a summary Minimum of the [Record ID#].  Then look that up down to the children.

Then make a new summary field of the Minimum of the Date field subject to the filter that the [Record ID#] = [Minimum Record ID# (summary field lookup)]