Relationship fields: Status
I have a project parent table and report child table. In the report table, my team creates monthly reports that include an overall status field. I'd like to be able to display that overall status fiel...
Forum Discussion
Here's a trick I've used many times. First, in the existing Project(parent)-to-Report(child) relationship, create a summary field [Record ID# of latest Report] that finds the max Record ID#. Then create a new "reverse" relationship with Report as parent and Project as child, and use [Record ID# of latest Report] as the reference field. In the reverse relationship, add a lookup field for the Report [Overall Status].
