Discussions

Expand all | Collapse all

How bring dates through a relationship from child to parent table

  • 1.  How bring dates through a relationship from child to parent table

    Posted 02-20-2019 03:09
    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?


  • 2.  RE: How bring dates through a relationship from child to parent table

    Posted 02-20-2019 12:54
    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.