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?