I'll preface this by saying Im a novice at access.
I have a query with 5 tables:
I only want each deal to show up once on the list, not multiple times for each iteration of the deal/property/client relationship. I currently have a datasheet subform with a totals query as the source and a filter field on the main form that is updated on the key up event. The totals query is giving me some issues, but the bigger issue is that I can’t search/filter on the 2nd, 3rd, etc. clients or properties that aren’t shown on the list but are still part of the deal that is shown.
I have a query with 5 tables:
- Deal Table
- Property Table
- Client Table
- Junction Table between Deals and Property
- Junction Table between Deals and Clients
I only want each deal to show up once on the list, not multiple times for each iteration of the deal/property/client relationship. I currently have a datasheet subform with a totals query as the source and a filter field on the main form that is updated on the key up event. The totals query is giving me some issues, but the bigger issue is that I can’t search/filter on the 2nd, 3rd, etc. clients or properties that aren’t shown on the list but are still part of the deal that is shown.