FInding similar values in differing fields in a fi

[merkaba22]

Ok

[dkemme]

Create a new field, Vehicle_ColorSearch. Allow the user to enter the color into this field. Create a script that copies the contents of Vehicle_Color search, enter find mode, paste into the Vehicle_Colorx field, new find request, paste into next colorx etc and perform find. A few tricks here, if you enter find mode and then try to set Vehicle_Colorx to Vehicle_ColorSearch, nothing will be there. Also, make sure the Vehicl_Colorx fields are somewhere on your layout, although not necessarily visible to the user though.

[Fitch]

Another possibility is to create a concatenated text field,

Vehicle_Color1 & "