data model help needed

Anonymous 

im not aware of your model in total , but 1 possible solution is : 

customer -- >  1 to many to transaction table 

customer -->  1 to many to vendor .

activate bi directional filter on the relation between customer and vendor  (  i would suggest reading about bi directtional filter before going through this solution , to know if it suits your model and wont introduce ambiguity later ) . 

this way, filter from vendor propagates toward transaction details via the customer table .

so example, 

if you have vendor  1 linked to c1,c2,c3,c4 

if you filter on v1,  the vendor table filter willl propagate towards the customer table and filters customer on 

c1,c2,c3,c4

then customer table's filter will propagate towards transaction and thus you can get the transactions per these 4 customers which are linked to the vendor 1 . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠