AnsweredAssumed Answered

Script the finds data in Field A or Field B OR Field C. . .  and then displays results

Question asked by sdurante on Mar 17, 2017
Latest reply on Mar 18, 2017 by philmodjunk

How would I best accomplish this:

In a layout that has 3 or 4 fields, I want to be able to fill one, two or all the fields with the result showing ANY matching data from another related table, not just records that have all fields matching.  In a portal I can do it for a single field, but when I add another I only get records that have ALL fields matching. Must I create a unique portal for each field?
For the query auto-fill drop-downs on the field of entry based on existing records in the related table  would be useful too.

I am using Ver.15 Pro.

Outcomes