I want a Donor list based on a specific Assigned Solicitor, but then for that donor list I also want to see any other solicitors that exist on the relationship record of those Donors
Query criteria is Assigned Solicitor Name = "XXX" - This shows all Donors with Assigned Solicitor Name = "XXX" Issue: - Some of the Donors in this list have additional solicitor names on their relationship tab that are not showing in query results.
1. Create a new query. For this example we will call the already existing query "Query A" and this new query "Query B".
2. In this "Query B" use no criteria.
3. In this "Query B" on the Output tab select the fields you want to display in the final results.
4. In this "Query B" select Tools > Query Options > Record Processing. Check the Select from query box and browse out to select "Query A".