What is the expectation when you select Customer A? As you say the combination of three makes it unique meaning there can be same customer in multiple rows. I believe thats what @ArunManickam also meant to ask.
For example For a contract there is
Customer A Vendor 1 Brand 1
Customer A Vendor 1 Brand 2
Is this the valid combo? If yes then what brand info do you want to pull.