Script for searching multiple fields
We run an art gallery and have artwork moving from in-house to conservators, framers etc. I have 8 fields in my movement report - 'movement from' 1 - 4 and 'movement to' 1 - 4. I want to write a script that will find, for example : Field 'Movement from 1' contains 'x' OR 'movement to 2 contains 'x'. I have only been able to get as far as 'Movement from 1' contains 'x' AND 'movement to 2 contains 'x' which obviously will show no return. Any advice much appreciated.