Parent table contains a property id.
Child table contains events using conditional value lists. Input by portal. an event set of records contains Date, Category, Event and a Comment field.
In the parent table, field titled Executive Summary, I need to display the latest dated comment from the Negotiations Category. Inside the negotiations category I have 5 different events. The events can happen at different times and occasionally have multiple occurrences of the same event.
I have tried different version of the calculation below and each time all I can get returned is the date.
Events::Event Category="Negotiations" ; Max ( Events::Event Date) Events::Event Comment;"" )
What I'm trying to say with the calculation is if the related event category equals negotiations return the comment from the latest dated event. If no matches are found return nothing.
thanks in advance for the help