AnsweredAssumed Answered

Using OR to search across multiple tables

Question asked by spinny on Mar 25, 2010
Latest reply on Mar 25, 2010 by RickWhitelaw


Using OR to search across multiple tables


Hi All,


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!