AnsweredAssumed Answered

Relationship with portal based on multiple fields

Question asked by MattLeach on Jun 5, 2012
Latest reply on Jun 6, 2012 by Stephen Huston

Here is my scenario.

 

I have two tables that i would like to relate: Transactions and Companies.

 

In the Transactions table, there are 6 fields which can contain the company (Buyer1, Buyer2, BuyerBroker, Seller1, Seller2, SellerBroker). Each of these fields is a drop down pointing to a value list of companies from the companies table.

 

What the client would like is on the companies layout, have a single portal that will list any transaction where the companie's name is in one of the 6 above mentioned fields.

 

I know i can accomplish this using 6 separate portals with a separate relationship for each but they would like this in one.

 

How would i accomplish this in a single portal?

 

Thanks

Outcomes