I have 3 Custom Lists. List A = Clients List B = Policies List C = Commissions. List B and C have a Lookup Field called "Client" that references List A.
I need a way to search all three lists to create a view that displays all clients with policies that have not received any commissions.
Is this possible or is it possible to create this with a Workflow?