Checking to see if record already exists

[Graham S]

I have a script that adds a new record into a table.

The script is called from a different database and a code is passed in as a script parameter.

How do I check to see if the record has already been added?

I figured I needed to do a find, but I cannot get it to accept the script parameter as the argument to the find.

[IdealData]

Have a relationship from db1 using your "code" as the relationship key. You can then check for the COUNT of related records before executing the rest of the script. I'm assuming that the "code" is unique.

[LaRetta]

Actually, using IsEmpty(childID) would be quicker than Count() - which has to count all related. And according to FM, the IsEmpty() test is perfect to check for related records. Just a thought ... :wink2:

[IdealData]

LaRetta is quite right.