So SQL is not exactly my ball park & the Tables I have to work with cant be modified.
TableA
Document,Customer,Store
DOC01,CUST01,STORE2
DOC02,CUST01,STORE2
DOC03,CUST02,STORE1
DOC04,CUST02,STORE1
TableB
Customer,Store,DefiningField,Value
CUST01,STORE2,"Is Real",TRUE
CUST01,STORE2,"STAFF",7...