Using OR to search across multiple tables
I have 8 tables that store data in my recruiting database. One for each major tournament we recruit at.
Would it be possible to perform a find that did the folowing
searched the rating field in all 8 tables
found any ratings that were either 1+ or 1
returned them as a report
If I were doing this in Excel I would use a formula that searched each table and then used the OR function. When I set the button up and specify find it only allows me to use the AND function - anyway to change this ?
MAC OSX 10.6.2 - FMPro10 - nearly 2 weeks experience with FM!