AnsweredAssumed Answered

Find Based on Field Content Matching

Question asked by DaddyO on May 1, 2010
Latest reply on May 1, 2010 by comment_1


Find Based on Field Content Matching


I am using FM Pro 10 on Mac OS (Leopard).


I have a database of baseball games where among other things I list the home team, the away team and the winning team. I would like to perform a find which tells me how often the home team won. In other words where the contents of the home team field match the contents of the winning team field. I would like to do this without having to specify the contents of the field(s). That is, I could perform a series of finds where I specify home team = BOS and then constrain that set by searching on winning team = BOS and then do the same for the other 29 teams but I'm lazy and it seems inefficient.


I apologize if I am missing something basic.