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.