Clear all but marked

[Robbydobbs]

I have sales twice a month and each sale I assign temporary buyers numbers. There are some buyers though that do have permanent numbers. After each sale I need to wipe out all the buyer numbers except those that are permanent. I was thinking that I would need a script that says:

go to field (buyer NO)

omit records that have permanent buyer field with "X".

perform Clear all

Is this correct or am I not even on the right path?

[Chuck]

It's kind of hard to tell given what you've told us. Does an X in the buyer NO field indicate that the buyer is permanent? Will a tempoary buyer NO ever have an X in it? If both of these statements are true, then here's a script that will do what you need.

Enter Find Mode []

Set Field [ buyer NO, "X" ]

Perform Find []

Find Omitted

Replace [ No dialog, buyer NO, "" ]

This script first finds all of the records that contain an X in the buyer NO field. Then it reverses the found set of records, so now the found set contains all the records that do not have an X in the buyer NO field. Then a replace is performed on the buyer NO field, which works on the found set, clearing the contents of the field. The buyer NO field must be on the current layout when the script is run.

Chuck

[Robbydobbs]

Thanks Chuck that is exactly what I need to know.