As I continue to work on this, I've taken a few different approaches, none seem to be working perfectly.
In the most recent, I am using the rank() function which allows me to identify the top results in both contract_use and contract_details, however I am seeing a very odd issue for one particular made-up customer.
When you filter on Customer CCC two results appear. As soon as you select a contract, it works correctly. Filtering also works as expected for all other customers.
ContractDetails2.twbx 47.4 KB