To start off, I am still pretty knew to FM7 and even newer to scripts, so if something is written wrong I am sorry. Anyway, in my DB I am trying to make a report that will list all our open orders at any one time. I have it set up right now with just a simple radio box ("Job Complet Y or N") that needs to be updated manually when a job is completed(which is a little clumsy but best way i could think of; would love suggestions on that). I set up a script that will work(once) but when I would go list all records, run it again, it would list every record regardless of what was checked.

I have two expenations I think can explain it. First, is that I'm setting up my layout wrong somehow. This is how I set it up. I did a search with "Job Complete=No", then switch to layout view and create a New Layout/Report using the wizard and then set up my criteria. When I switch to browse view it is perfect. Second, my script is wrong because it is not actully "Finding" my records.

Here is my script:

-Enter Find Mode [Restore]-(action) Find Records-(criteria) Order Entry::Job Complete [=No]

-Go to Layout ["Open Orders-Shop"(Order Entry)]

-Enter Browse Mode[]

-Sort Records [Restore;No Dialog]

Thank you for any help.

Try

-Enter Find Mode [Restore]-(action) Find Records-(criteria) Order Entry::Job Complete [=No]

-Perfom Find

-Go to Layout ["Open Orders-Shop"(Order Entry)]

-Sort Records [Restore;No Dialog]

You need to do a Perform Find after entering Find Mode. If you do not the find is not performed and when it got to Enter Browse Mode it ignored your Find critera

You need a Perform Find [ ] step after entering Find Mode, or nothing happens. Is the find performed on a layout associated with the Order Entry TO?

Thank you very much. To both of you. I got it to work how I want it to now.