Enter Find Mode
set Field [YourTable::Quantity Balance ; "< " & .5 ]
Set Error capture [on]
If [ Get (FoundCount ) > 0 ]
Show Custom Dialog ["These materials have a low balance..."]
You can use File | File Options to set this script to run each time it is opened.
thank you for your reply. I tried your script but It was unsuccesful... I made my own script because iI forgot to mention that I would like also to appear the names of the materials in the dialouge box. but I based from your own..the script goes like this
Enter find Mode
set Field [Materials::Quantity Balance; " ≤ " & .5]
Perform Find 
Set Variable[$found; Value:Get (FoundCount)]
If [$found >0]
Set Variable [coounter; Value:1]
Set Variable [$names & GetNthRecord(Materials::Materials Name; $counter ) & "¶"]
Exit Loop If ($counter = $found)
Set Variable [$counter; Value:$counter + 1]
Show Custom Dialog ["Low Balance"; Materials with low balances: ¶" & $names]
But still I'm unsuccessful...kindly improve and correct my script.
thank you very much.
How is it unsuccessful? That will clue me in on what we need to do differently here. Does the find work to find your records?
If you are not finding the reocrds you expected to find, is quantity balance a number field, calcuation field or a summary field?
Sorry I forgot to mention, the Quantity Balance field is a Calculation field (Quantity Balance...Calculation...Indexed, Quantity Received - Quantity Used). It was unsuccessful in the sense that it only shows those materials having zero balances.
Ok, you mentioned a 50% re-order level, so I incorrectly assumed this was a percentage, hence the 0.5 entered as criteria. You need one more calculation field: Quantity Balance / Quantity Received to compute the percentage on hand. Use your script to enter "< " & 0.5 in this field instead of Quantity Balance.
Thank you very much Phil, I got It.
Another additional help & favor...how about if I want only to see those materials having low balances excluding those materials having zero balance. thank you so much.
Add these steps after the Set Field step:
Set Field [Materials::Quantity Balance ; 0 ]
Omit record in find mode selects the Omit option just like clicking that button does in a manual find.
I got it..youre a Great help to the forum specially like us who are new to filemaker...Thank you very much.