I am working on a putting together a list of certain records. To add these records to the list, I have assigned the list a name using a Temporary Global field (Consignment Name) and then Set my Consignment Field to have this particular text (the Consignment Name) added to it.

(It is possible that a record will have multiple Consignments, so I add each new Consignment Name to the Consigment Field as a calculation).

Now, in my script, where the Temporary Global Field is still the same Consignment Name - I want to script a Find where the Consignment Field has this Temporary GLobal Field. Does anyone know how to do this? It is not a Find I will have particular criteria for in the script - it is just where the Consignment Field = the Temporary Global Field. (Again, it is possible that there is more than just that Temporary Global Field Text in the Consignment Field - possible that there are other previous Consignment names in the field.

Let me try to explain: Let's say I have assigned a Consignment list the name "Consignment #1" - I set the Global Field as "COnsignment #1" and then go through my records adding certain records to this list by Setting the "Consignments" to have this "Consignment #1" text in it. (I do not set the field to = it, I set the field to include whatever was previously there and then to add it). So it is possible that the Consignment Field = "Consignment a, Consignment #1", etc... Then I want to find the records where the Consignment Field has the current Global Field Text in it, i.e., = "COnsignment #1".

I just can't seem to figure out how to script this find...any ideas? Help!

Thanks, sarah

Will be better if you can attach the little part of your file here.

But this did not work?

Enter Find Mode

Set Field[Consignment Field;Temporary Global Field]

Perform Find

Your script should work but I a not sure how the find will react to special characters.

At this case i think that works

Set Field[Consignment Field;"""&Temporary Global Field&"""]

But this did not work?

Enter Find Mode

Set Field[Consignment Field;Temporary Global Field]

Perform Find

This worked perfectly! I am a beginner pasting all of this together - for some reason there are simple things that I am still figuring out - thanks a million!