BCHasRows : Validation Without Scripting

To check/search in child Bus comp field values for some validation  without scripting.           For Example:

When the Specified Account has any "Active" child Activity, the Activity flag should be true

 Implementation without scripting:

Create a calculated field: Check Activity

• Calc Expression: BCHasRows("Account", "Action", '[Account Id] ="' + [Id] +'" AND  [Type] = "Active"',"All")
• Returns Y, if any child activity found.
• Create a User property “On Field Update Set” to set the Activity Flag ; Value : “Check Activity”, “Activity Flag”          

 Syntax:  BCHasRows ( BO , BC , search_expr, visibility)