I'm looking at modifying my database to omit all records that do not have a valid sales quote number. Currently the correct format for Sales Quote numbers is either 4 digits or RAMXX-XX-XX where X is any number.

At the moment some sales quotes are blanks, while others are just text, these are the records I want to omit.

And instead of going through the records one at a time and omitting them this way I was hoping I would be able to create a script to do the work for me.

And and all help would be greatly appreciated

Try doing a find with two omit requests, one for:

==RAM@@-@@-@@

and one for:

==@@@@

Thanks for the tip, but how would I accomplish this in 1 step, I'm looking to associate this with a button

You can define the button to Perform Find with the above requests.

A button can also run a script with any number of steps, so I don't see why it HAS to be one step - but in this case it can.

Thanks, I finally got it working, I hadn't realized that I could just use the button commands to find multiple requests