simple finds with FM server 11- debug server

[crazybake]

Not positive if this is a script syntax issue or a server performance issue. I do know that the following error was not happening when I had the DB local.

The FM Server 11 hosted database is a simple checkout system for students to checkout equipment. I am worried that there may be too many scripts being executed consecutively over the network (these scripts are run locally).

An item number is entered into a custom dialog box (2 buttons, cancel, ok). The first script checks to see if an item is broken, missing or has been blocked from checkout, the next script sees if the item is currently checked out, the third checks to see if the item is reserved by someone. All of these are performed with find requests. If the resulting find is 0, then it states that the item is not checked out and available....

The issue is that when an item is entered (and the report log shows it is checked out or "1") the db will report that the item is available. So, I start from the beginning, renter the number a second time and this time it finds correctly. I tried adding a pause to the script, but that made it worse (it reported that the item was reserved every time... weird!) I Also notice that when the system reports incorrectly, a window that is supposed to close doesn't (which tells me that the script is not completing?).

Can someone help me with debugging this problem (not necessarily what is wrong with the database) but the proper approach to isolate what a potential problem might be, on on which end the issue is happening.