Presumably, you have this relationship:
YourTable::QueryName = YourTable 2::Name
Change it to:
YourTable::QueryName X YourTable 2::Name AND
YourTable::QueryPostCode X YourTable 2: Postcode
Then, open portal set up and enter this filter expression:
YourTable::QueryName = YourTable 2::Name OR
YourTable::QueryPostCode = YourTable 2::Postcode
and you'll be able to display records in the portal with matching name or postcode.
Using the X operator and including both query fields in the portal's relationship ensures that the portal should update automatically when you select or enter values into either of the two query fields.
This is a fairly simple filter expression to get you started. More sophisticated expressions--including some that can match by partial text entered into a query field are also possible.
You may find this demo file's search portals of interest: https://www.dropbox.com/s/0pm1gdqcfi2ndpv/EnhancedValueSelection.fp7
Thank you Phil, You are the best.
One tiny followup question:
I simplified my first question to find out the process which now makes my second question seem a little strange. If I dont enter any text into QueryName; I now get all the records which dont have a Name (this is correct and exactly what I would expect). Can I put in a 'If not empty' then use the data to filter statement? I tried, but it did not go well...
I'm sorry, I walked away for a moment and found an answer. If anyone else needs to do this in the future then the Portal filter Calculation could be:If ( IsEmpty ( YourTable::QueryName) ; "" ;YourTable::QueryName X YourTable 2::Name )orIf ( IsEmpty ( YourTable::QueryPostCode) ; "" ;YourTable::QueryPostCode = YourTable 2::Postcode )