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.