Hi all

Is there a way of suppressing the find dialog box when no records have been founded. I am searching three db for welders qualification who have left the company. I enter the welder id in one db and use the set field option to install the id in the three db and run three external scripts sreaching for his qualification. If no record exist in a db, i would like to just exit the db and continue to the next script without having to press the cancel button. It is not possible to make one db as the forms are different. Can this be done

Thanks

Lionel

Set Error Capture [On] at the beginning of your main script.

In your other dbs, after your Perform Find step, add

If[not Status(CurrentFoundCount)]

Exit Script

End If

In the final db (the one with the last script), I would use

If[not Status(CurrentFoundCount)]

Show Message["No welders exist with that id."]

Exit Script

End If

Hi Queue

Thanks for the reply

Lionel

If you're only searching by id, you could do it with a relationship instead of a Find, and it might run faster too:

If (IsEmpty(db1::id))

.. # continue

Else

.. Go to related record (show, db1)

End If

... or something along those lines.

Even better. I would have thought along those lines eventually.