This should be simple, but I don't know enough of the functions to find a quick solution.  I need to display a custom dialog box only when there are related records present, AND any of those records is stll listed as open (text field selected either open or closed by user).

 

So - if no related records, do nothing.

 

If related records exist, and any of those records are open, display dialog box.

 

I can do the first two conditions, but not sure how to test if any related records are open.

 

 

Suggestions?

 

 

 

 

 (text field selected either open or closed by user)

 

Do you mean the text field contains the text "Open" or "Closed"? If so, you can test for:

 

not IsEmpty ( FilterValues ( "Open" ; List ( Related::Textfield ) ) )

 

If this return True, there is at least one related record whose Textfield value is "Open".

 

 

This could be easier if you used a Number field - with 1 for True (say Open) and 0 (or empty) for False.

Thanks comment - your suggestions always save the day!