Dear
New but eager to learn
No Problem.
I am assuming that what you mean is to locate the most recently modified Task for the Project and then float up the comment from that Task up to the Parent.
Make a summary field on the Relationship between the Projects and Tasks to summarize the Maximum [Date Last Modified]. Name the field [Tasks Date Last Modified]
Lookup[Tasks Date Last Modified] down to tasks.
Now, make a summary field on the relationship again, but this time select combined text summary of the comments field and then limit the Summary to just tasks where the [Tasks Date Last Modified] equal the [Date Last Modified].
Now the Project will have the comment but it will appear in a "pill" multi select type format.
If that bothers you make a new formula text field to use on records and reports
ToText([Most Recent Task Comment combined text format])------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
