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 table. Do I need to create a new one to many relationship for the current child table to the current Parent table flipping them in this new relationship or can this be done in the current relationsip?
Thanks
Brian
Qrew LegendIs 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#]. The 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)]
Hi Mark, Thanks for the reply. Yes, the field I want to summarize up to the parent is a Date field. I created summary "Minimum Record ID#" using [Record ID#] as seen below.
The Minimum Record ID# field ha the following attributes:
I did not understand the last part: "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)]".
Am I doing this in the same relationship as the above? So, another summary field created in the same location as "Minimum Record ID#" but setup the following way:
Summary
Minimum for the field: [EFP Date]
How do I do the: [Record ID#] = [Minimum Record ID# (summary field lookup)]"? Is this in the Child Table?
