Hi,

I have the staus area hidden in my 8.5 solution and I need to allow users to build complex find with multiple and/or/isnot find criteria.

In find mode I can use a 'new record' buton to add an 'or' criteria, and I can use an 'omit record' button to add an 'is not' criteria.

But with the status area hidden, is there a way to show users whether they're looking at a find request rather than an omit request?

Thanks,

ft

http://www.filemaker.com/help/FunctionsRef-258.html

--sd

Thanks for the pointer. I also found the useful function

get(requestnumber)

I created my solution as follows:

1. Created 2 globals in the interface file called FindOrOmit and NumberOfRequests. I placed these globals on my find layout.

2. I built 4 buttons on the find layout; new, omit, forward, back. I gave them each script paramenters.

3. I created a script, triggered by the buttons created in step 2, which sets initial values for the fields created in step 1 to start the search

4. I created the following (rough) script which sets the globals created in step 1 each time a button is pressed:

#New find request 

If [ Get(ScriptParameter) = "new" ] 

New Record/Request 

Set Field [ Interface fields::FindOrOmit; "Find" ] 

Set Field [ Interface fields::NumberFindRequests; Get ( RequestCount ) ] 

Halt Script 

End If 

#Omit request 

If [ Get(ScriptParameter)= "omit" ] 

Omit Record 

If [ Get ( RequestOmitState ) =1 ] 

Set Field [ Interface fields::FindOrOmit; "Omit" ] 

Else 

Set Field [ Interface fields::FindOrOmit; "Find" ] 

End If 

Set Field [ Interface fields::NumberFindRequests; Get ( RequestCount ) ] 

Halt Script 

End If 

#Forward one criteria 

If [ Get(ScriptParameter) = "forward" ] 

Go to Record/Request/Page 

[ Next ] 

If [ Get ( RequestOmitState ) =1 ] 

Set Field [ Interface fields::FindOrOmit; "Omit" ] 

Else 

Set Field [ Interface fields::FindOrOmit; "Find" ] 

End If 

Set Field [ Interface fields::NumberFindRequests; Get ( RequestCount ) ] 

Halt Script 

End If 

#Back one criteria 

If [ Get(ScriptParameter) = "back" ] 

Go to Record/Request/Page 

[ Previous ] 

If [ Get ( RequestOmitState ) =1 ] 

Set Field [ Interface fields::FindOrOmit; "Omit" ] 

Else 

Set Field [ Interface fields::FindOrOmit; "Find" ] 

End If 

Set Field [ Interface fields::NumberFindRequests; Get ( RequestCount ) ] 

End If 

thanks,

ft.