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.
