I have an problem that I cannot figure out how to solve. It's a bit complicated, but I think it may be unsolvable within Caspio. Anyone who can solve this gets a gold star because I have tried everything.
I have a table of customers example (C1, C2, C3, ... Cn ) and a table of vendors (V1, V2, V3... Vn).
Every customer can have deals from multiple vendors e.g.( Customer C1 can have deals from vendors V1, V3, V4, C2 can have deals with V2, V4, V5) etc.
Vendors can have different deals with one or more customers, but only a single deal with a given customer.
This yields a