Show Message script

[Elrond]

Hi everyone I'm new to this site . I joined because I'm having trouble creating a script and no one in my organization is well versed in Filemaker except me. So I thought I could make use of your expertise.

The problem is that I'm created a script that takes the user to a Find mode, populates a field called Form_Status with a valid value of "Active" (the valid values for this field are "Active, Inactive") and then moves to another field called Job_Title and waits for the user to enter the rest of the criteria to search for. The problem start there. I'm trying to create a script that does the following: When the user clicks on the botton I created on the layout to perform the Find

without entering additional criteria, displays a message box stating something like "Please, enter a valid value to search for" then they click the button on the message box and return to Modify the search, but if they do enter a value I want to show a message if no records are found that says "No records found click on ok to try again or Cancel to return to the main menu" but if there is found records to go to a different layout and display the results of the search.

So far I haven't been able to get it to work right.

One more thing, the Status area is hidden so the users of this database will not be able to use it.

Please, if you have any ideas let me know I've tried everything I can think of and I can't get it to do what I want it to do.

I appreciate your help.

[cdefeciani]

I used an If/Else statement to solve this issue-- and I also am hiding the status area in IWP from the end user, although since IWP will only show 25 records now I am stuck trying to create a button that will run a script that then shows the next range of records. Note that I have the records set to view as a list and that is the layout that presents the found set; a No Records Match your request layout with navigation buttons to return the end user to the start search layout again Note: the 401 error code is the "No Records Match Your Request" error:

*****************************

If [Get(LastError) = 401]

Go to Layout ["No Records Found"]

Else

Sort Records

Commit Records/Requests

Show All Records

End If

********************************

Can someone now tell me how to build a script for a navigation button that will allow the user to go to the next range of records? For Instance: the initial find request shows me records 1-25 in a list interface. Is it possible to create a button that would take the end user to records 26-50, 51-75, 76-100 and so on?

Thanks for any and all assistance.

Edited August 25, 2005 by Guest