Query check CCI if no then none

Data Integrity Checks
Summary:	If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component
Related:	CCI Picklist, CCI Component, No procedure performed
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_CCI_if_no_then_none
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2021-01-20
Backlogged:	true

• Cargo

• SMW

• Categories:  

• form:

Log

• 2021-01-20 - the check never worked because it wasn't matching Pat_ID correctly; this was fixed today, meaning effectively this query was only implemented today, so changing the implementation date above.