+9I 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
+24Is 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)]
+24There was a step in my instruction to look up that summary field of the minimum record ID down to the child table. Once you do that, then when you make the next summary field, you will have a filter for it
Now you have not really explained to me if you have 10 children for the parent how do I know which child record's date field do you want summarized.
If you simply wanted to know the minimum date of all the children, then you can just do a summary minimum on that date field. But my solution is a little more complicated because I made the assumption that you wanted the date field from the very first child to be summarized, back up to the parent record.
Feel free to post back if it's still not clear or I'm not understand understanding your use case
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
