How do I build a query in IQA that will list only Company Records* with at least 1 current Member** on their roster?
I have a hunch that I will need to use multiple instances of CsContact and involve the Company ID field somehow, but I can't seem to parse out the Join and/or the Filters properly. Everything I have tried comes out wonky.
All it needs to show is the record ID and company name of those company records. No individuals on the roster need to show up in the results.