I have a Projects table and Tasks Table.
The Tasks are set with various status but only one task in the table will be "In-Progress".
I want to be able to show the In-Progress Task Number or Name in the Projects Report List.
I thought about creating a Current Task field in the Projects table and then was hoping to populate it using Dynamic Form Rules but I don't think this can be done.
Is there a recommended way to do this?
Make a summary field of the Maximum of the Record ID# field subject to the filter that the status is In-Progress. Call it [Record ID# of the In-Progress Task].
Then make a new verse relationship where one task is related to many Projects based in that field. Then just lookup any data you need to get to the Parent Project.