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

Title

Using OR to search across multiple tables

Post

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 ?

 

Thanks

 

Andy

 

MAC OSX 10.6.2 - FMPro10 - nearly 2 weeks experience with FM!

Outcomes