Scripting a particular find

[snatkins]

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

[aaa]

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

[aaa]

But this did not work?

Enter Find Mode

Set Field[Consignment Field;Temporary Global Field]

Perform Find

[Oldfogey]

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

[aaa]

At this case i think that works

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

[snatkins]

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!