Cannot select blocked specification 1s when adding a firm

This section provides information on a validation error.

Workflow Table Type Description Workflow Conditions
Firm Insert Blocked Specification 1 cannot be selected (Add)
Action Column (Field) Change Properties Description Action Conditions
Column (Field) Change Column: ClientCustomTabFields.CustWorkflowBlockedSpecification1

New Value SQL Expression:

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

Use this Calculation: 'Y'

Otherwise, Use This Calculation: 'N'

Test if blocked Specification 1 was selected ClientCustomTabFields.CustSpecification1 not empty
Validate Error You've chosen a blocked Specification 1. Please select a different Specification 1. ClientCustomTabFields.CustWorkflowBlockedSpecification1 equals Y