Can you spell out the relationships involved here? Especially the match fields used?
It is possible that you might need to do two things here:
- Have a calculation that determines wether or not this max time has been exeeded or not.
I would think maybe an IF statement that sets a value in a field.
IF (Portal1::SumTime > Portal2::MaxTime ; "Overtime" ; "" )
- Then when the value "overtime" appears in that field "MaxTime" your conditional formatting kicks in.
Kind of like the formula:
Portal2::MaxTime = "Overtime"
and this results in a fill color, or text color, or ...
Thank you for the replies, I may have confused the matter a bit by mentioning the second portal.
So the main layout is for "aircraft". In this layout, I have a field <<status_entry::max_hobbs>> which takes the max from the status_entry portal and displays it on the layout (there may be hundreds of status records as the aircraft time is updated).
The "compliance" portal contains records specific to the aircraft. Some of these compliance portal records also have times (when they are due).
I would like to have each portal record highlight when the time on the portal record exceeds the time from the main layout <<status_entry::max_hobbs>>...
The relationship is:
Hope that clears it up a bit...
So your relationship to this portal is: (But with your names used in place of mine...)
Compliance::__pkAircraftID = Status_Entry::_fkAircraftID
and the conditional formatting is specified for objects in the portal to status_entry; they all need to refer to the same value computed as a calculation field in compliance?
I'm having trouble seeing why you are having problems with a conditional format.
A conditional format that compares a value from a field in the portal's table occurrence to a value from a field in the layout's table occurrence should work without any issues.
Perhaps you should post your conditional format expression that doesn't work.
Thanks - here it is:
(right click -> conditional formatting)
"Value" - "is >=" <<status_entry::max_hobbs>>
Which looks correct to me though I usually use the formula format:
Self > status_entry::max_hobbs
Just to check the obvious here, go to layout mode, open layout setup and check the "show records from" drop down. Does it show this exact text?
And since max_hobs is a calculation field, is number or text specfiied as the result type? If you selected text, the value will look correct but won't evaluate correctly in the conditional format expression (or any other expressions that compare values to it).
Fixed the issue - deleted the "<< >>" from the variable!