inserting values in field by find
Bit of a noob alert here.
I have a FM database in which one of the fields contains county information. It consists of three letter abbreviations for any particular county. Typical would be CEN for "Center" County.
What I want to do is to have a script search for the counties in that field, then if that particular value is found, to cause the value of another field to equal 1. If not found, the related field is 0. Then after the search for all of the counties is complete, the total number of counties is added from the related fields, then summed.
In this case, there would be around 70 finds.