Learned how to use global fields (and use a calculated field to check if the global is empty) to allow customers to filter portals. In the attached, you can see it worked well on the upper left side. I've selected a customer code and it filtered by that code. However, I wanted to also filter by our four departments: W-Properties, W-Vacancies, W-Businesses, and U-Vacancies.
However, because typically an Agent's note will only apply to one property or vacancy or business, most records have an empty field in one of the depts. What happened when I added the first dept to the Relationship graph is that only those records that had a code in that field appeared in the Notes portal. The rest disappeared. If I add the other three more and more records disappear. How do I force records to show even if their Prop Code or Vac code is empty (NOT that the global filter field is empty, which is already accounted for). Thank you.