AnsweredAssumed Answered

Displaying Portal Records if One of Two Conditions Are Met

Question asked by joey_legos on Sep 30, 2014
Latest reply on Sep 30, 2014 by wsvp

I have a database that tracks issues that occur between companies. Two tables, Company and Issues. On the company table, each company has a unique identifier code. When a new issue is created in the issues table, the user is able to enter up to two companies that are affected by the issue (i.e. Company A is in dispute with Company B over shipping terms). Company A's code is then stored in issues::Company Referenced 1, and Company B's code is stored in issues::Company Referenced 2. I'd like to have the portal on my company layout display records if the company is referenced in issues::Company Referenced 1 OR issues::Company Referenced 2. Is this possible? Thanks.