Omit specific records from found set

[svalenti]

Using Version 7. I have a table with 3 types of clients (Inquiries, Transitions & Clients). Some of these are inactive. I need to make a script that will:

1) Find all the "Inactive" records (using the field: [status])

2) Omit the records where Status is = to "Inactive"

3) Within this found set, I'd like to find all the records that are "Inquiries"

4) then let the user input any other find criteria using fields on the layout

What they should end up with is records that are "Inquiries", not "Inactive" and have a few other perameters that they specify.

Thanx in advance for your help.

[Søren Dyhr]

I would do it this way:

Show All Records 

Go to Field [ Untitled::Aux1 ] 

Enter Find Mode [  ] [ Pause ] 

If [ Count ( Untitled::Aux1;Untitled::Aux2;Untitled::Aux3;Untitled::Aux4 ) ] 

      Perform Find [  ] 

      Constrain Found Set [ Specified Find Requests: Omit Records; Criteria: Untitled::Status: "Inactive" ] [ Restore ] 

      Constrain Found Set [ Specified Find Requests: Find Records; Criteria: Untitled::Clients: "Inquiries" ] [ Restore ] 

Else 

      Enter Browse Mode 

      Show Custom Dialog [ Title: "Error"; Message: "Empty request???"; Buttons: "OK" ] 

End If 

This script pauses and expects the user to enter something to search for and continues by hitting enter pretty much like googling!

--sd

[svalenti]

The 2 Constrain Found Set steps produce no results. I get the "No Records Found" dialog even though there are records that meet the criteria.

[Søren Dyhr]

Did in case though ...2 things to check:

1) is it an omit request in first constrain??

2) Spellingerrors?

Well the easiest way to check would probably be to use the print script preview ...copy it to a word processor and compare it with what I entered here in my reply - simple comparison of scriptlines would do because you should doubleclick to investigate each.

--sd