Omitting Records from a found set

[TweakSF]

Hi All, I am really new to FMP development and have run into a problem with one of my scripts. I have a script that searches record date ranges in the database and I need to be able to omit records that are within certain parameters. The parameters are taken from a drop down table. I have tried several different approaches and now the script seems to be generating new records?!

the script I have is as follows

Set Error Capture [ On ] If [ IsEmpty ( Inventory::Start Date ) ]

Show Custom Dialog [ Title: Inventory::Start Date; Message: "Start Date must have a value. Please reenter"; Buttons: “OK”, “Cancel” ]

Exit Script [ ]

End If

If [ IsEmpty ( Inventory::End Date ) ]

Show Custom Dialog [ Title: Inventory::End Date; Message: "End Date must have a value. Please reenter"; Buttons: “OK”, “Cancel” ]

Exit Script [ ]

End If

If [ Inventory::End Date < Inventory::Start Date ]

Show Custom Dialog [ Title: "End Start"; Message: "Hey Silly the Past is Not the Future try again!"; Buttons: “OK”, “Cancel” ]

Exit Script [ ]

End If

Enter Find Mode [ ] Insert Calculated Result [ Inventory::Shot_Completed; Inventory::Start Date & "..." & Inventory::End Date ]

[ Select ]

Perform Find [ ]

New Record/Request

Set Field [ Inventory::Shot_Status; " = NotShot or Killed " ]

Omit Record

Constrain Found Set [ ]

If [ Get ( FoundCount ) = 0 ]

Show Custom Dialog [ Title: "Alert"; Message: "You have no records for this date range"; Buttons: “Close” ]

Exit Script [ ]

End If

If[Get(FoundCount) >1]

Go to Layout [ “Record List” (Inventory) ]

Exit Script [ ]

End If

Sorry for the long post I am at wits end right now and any help would be greatly appreciated

[comment]

now the script seems to be generating new records?!

Well of course it does:

...

Perform Find [ ]

New Record/Request

...

After performing the find, you are in Browse mode.

Can you explain, in plain language, what are you trying to find?

[TweakSF]

Thanks for pointing that out, by changing the placement of the new request prior to performing the find it now seems to work