How to write a script that would clear data from two different fields in multiple records

[svolin]

The intro to my problem is going to be long because I think it requires a degree of explanation.  I apologize in advance for the length.

 

I have a project that involves, at present, designing restaurant and industrial kitchens (it may expand to all food areas).  I have listed several hundred different pieces of equipment and have a file of printouts of their "overviews" and "cut sheets", or specifications.  When drawing blueprints, each piece of equipment must be shown (to scale) and sequentially numbered.  A copy of the Overview (general description and picture) and the applicale cut sheets, in sequential order, must accompany the primary set of blueprints.

 

Having this list greatly simplifies a designers job because no two kitchens aree alike - Customer size, construction budgets, etc.  So, what i want to do is to be able to 'pick and choose' which pieces of equipment I will be using and, from there, print the appropriate forms in the correct sequence.  And that's where the problem arises.

 

I have scripts that do almost everything I need - except that, after creating a "To Print" list which shows the total file, I have a radio button field (Yes, No) to determine whether or not to include in printing, and a second field to set the order of printing (to correspond to the equipment sequence numbering of the blueprint.  The problem is that I can't get the two fields to clear or revert to blank status so that I can establish a new printing order.  I've worked around the Yes, No by replacing the field contents to No, but that's a kludge, and am not happy with it.

 

Are there script steps that will allow me to clear both types of fields before displaying the complete list?

 

Thanks for any help, and thanks too, if you have sat through and read the whole thing.

[doughemi]

Replace Field Contents[No Dialog; YourField; ""]