AnsweredAssumed Answered

Script is omitting a record that doesn't match script criteria... why?

Question asked by bosslisa on Nov 6, 2008
Latest reply on Nov 6, 2008 by bosslisa

Summary

Script is omitting a record that doesn't match script criteria... why?

Description of the issue

I'm using a simple script in an inventory database.  The script does a find of the available inventory by omitting records that are marked Sold (checkbox) and/or Returned (checkbox).  The problem is that when I run the script it omits one of my records even though the inventory item is not checked as Sold or Returned. I set it up in ScriptMaker as follows: Perform Find [Restore]: Specify Find Requests-1. Action= Omit Records, Criteria= Inventory::Sold: [*]1. Action= Omit Records, Criteria= Inventory::Returned: [*]  That's it!  I used * to designate that the Sold and Returned checkboxes be marked, is there a better way to indicate that? The script is finding everything correctly except for one record! 

Outcomes