I posted a sample file to explain what i'm trying to do. In the employee record i want the field flag to have a value of "on" if any of the related records does not have a value in the stop field. This needs to work even if the portal is not on the layout. thanks

trying to figure out how to post the file

Untitled.fmp12.zip

So you were using LineItem:lineItemFlag instead of the stop field in the calculation. set the flag field calculation to:

 

If ( IsEmpty(LineItems::stop) ; "Off" ; "On" )

 

or something like that, if you dont want the Off.

 

 

Good Luck with your solution!

Gabe

I think I would put the flag in the related data portal, I also used Conditional Formatting so that it would stand out. You don't need a default in a case statement, it will default to empty.

riverbend.fmp12.zip

Edited June 18, 201312 yr by Lee Smith
left out the word portal

IF you need the LineItems flag calculation which produces the "on" for other things then you can keep it but you do not need it at all to achieve what you wish.   In Employees,  your flag calculation (result is text) could be:

 

Case ( Count ( LineItems::keyID ) > Count ( LineItems::stop ) ; "On" )

Yes, that works. Thanks

 

IF you need the LineItems flag calculation which produces the "on" for other things then you can keep it but you do not need it at all to achieve what you wish.   In Employees,  your flag calculation (result is text) could be:

 

Case ( Count ( LineItems::keyID ) > Count ( LineItems::stop ) ; "On" )

Yes, that works great. Thanks