i am having a few probs find a way to compare to text fields

i want my users to beable to enter text in to a global field by means of a check box and then have a script that will loop through the records checking for the text or 'checked boxes in another field and remove the text in the second field

does any one now how to do this or have any clues how it might be done

cheers

Walker

In your loop

If ["PatternCount(The Field you want to check, Your Global Field)"]

Set Field ["The field you want to check","Substitute (The field you want to check, Your Global Field, "")

End If

Try on a sample database, or on a single record before you try it on your entire database

HTH

that looks cool, will try it out and get back to you

i have tried, it works great

i had to change each of the fields at the start of the script to have a 'return' at the start and end of the field, to get them to match up and stop any mismatched substitutions

thank you for your help