Query check CCI TISS if no then none

Data Integrity Checks
Summary:	If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa
Related:	CCI Picklist, No TISS Item (TISS Item)
Firmness:	hard check
Timing:	incomplete
App:	CCMDB.accdb
Coding:	query check_CCI_TISS_if_no_then_none
Uses L Problem table:	not relevant for this app
Status:	ready to implement
Implementation Date:
Backlogged:	true

This check can be done even on incomplete data, since while there might be no data, there should never be inconsistent data.

Log