I'm new to FMP scripting and working on cleaning up a rather large database. I need to create a script that searches for specific field value and then translates the data into values for several newly created fields. All are known values and text based fields. Basically something like this:
Find all records with Field1 = 'Green'
From those matches insert 'Blue' into Field2 and 'Yellow' into Field3
Is this easy to do with a FMP script?
Could you give me an idea as to the syntax or an example?
Thanks!
Scott
Find all records with Field1 = 'Green'
From those matches insert 'Blue' into Field2 and 'Yellow' into Field3
Is this easy to do with a FMP script?
Could you give me an idea as to the syntax or an example?
Thanks!
Scott