Cannot select blocked specification 3s when editing a firm

This section provides information on a validation error.

Workflow Table Type Description Workflow Conditions
Firm Change Blocked Specification 3 cannot be selected (Change)
Action Column (Field) Change Properties Description Action Conditions
Column (Field) Change Column: ClientCustomTabFields.CustWorkflowBlockedSpecification3

New Value SQL Expression:

If this is True: (select custBlocked from UDIC_Specification3 where UDIC_UID='[:ClientCustomTabFields.CustSpecification2]')='[BLOCKED]'

Use this Calculation: 'Y'

Otherwise, Use This Calculation: 'N'

Test if blocked Specification 3 was selected ClientCustomTabFields.CustSpecification3 not empty AND

ClientCustomTabFields.CustSpecification3 has changed

Validate Error You've chosen a blocked Specification 3. Please select a different Specification 3. ClientCustomTabFields.CustWorkflowBlockedSpecification3 equals Y