5 Replies Latest reply on May 1, 2010 4:56 PM by comment_1

    Find Based on Field Content Matching

    DaddyO

      Title

      Find Based on Field Content Matching

      Post

      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.