Forum Discussion

MaxWilliams's avatar
MaxWilliams
Qrew Trainee
6 years ago

How bring dates through a relationship from child to parent table

Hi,
I have a child table with a field of dates, I want to bring these dates through to the parent table. There is only one date for each project so basically just want to replicate the dates on the child table on to the parent table.
I have tried doing a summary of the field how ever it says I cannot which I assume is because it is dates.
How can I do this?

1 Reply

  • If you are looking for a summary like a maximum or minimum, then that should work easily.
    If you ar looking to have a Combined Text Summary field of all the unique, then you will need to first make a new field to convert the date to a text field.

    For example

    ToText([my date field])

    Then do the Combined text summary on that text field. Combined text summary fields can only combine text fields.