How do i display text values in summary field if i cannot make a reverse relationship?
Attached image poses the question better than the text below:
Question: How do I display the Date of the most recently completed work order on the Site record AND pull in the [Work Order ID] to the Site record???
I was able to create a summary field to pull in the maximum [Date Completed] for any Work Order related to that site, but I can?t figure out how to get the [Work Order ID] pulled in since the data fields are text instead of numeric. I also can?t create a reverse relationship based on the [Record ID#] because the key fields are text fields...
I created a summary field on the Sites Table: [Record ID# for Most Recently Completed Work Order], but I?m unable to get that into the Reference field when I make the reverse relationship.
Question: How do I display the Date of the most recently completed work order on the Site record AND pull in the [Work Order ID] to the Site record???
I was able to create a summary field to pull in the maximum [Date Completed] for any Work Order related to that site, but I can?t figure out how to get the [Work Order ID] pulled in since the data fields are text instead of numeric. I also can?t create a reverse relationship based on the [Record ID#] because the key fields are text fields...
I created a summary field on the Sites Table: [Record ID# for Most Recently Completed Work Order], but I?m unable to get that into the Reference field when I make the reverse relationship.
