Dynamic Portal filtering from multiple fields
Firstly, I promise I have googled this and found examples I dont understand.
to simplify: I have one table with 4 fields; Name, Postcode, QueryName, QueryPostcode. I have made a self join relationship with Name and QueryName. On the layout I have a Portal listing all the Name & Postcode records from the new table2 as well as the Query fields.
If I enter text into theQueryName field, the table2::portal filters beautifully....
How can I get the same to work for both the QueryName AND / OR the QueryPostcode field?
Thanks for your time