How do I check for duplicates? I want to prevent a user from entering a duplicate report for the same department.....

Is there a script I can run before they get to add a new record?

Thanks in advance

Is this what you want?

Dup_Test.zip

Thank you soooo much

I have something similar to this... but it's not working.

It says nothing was in the found set- do I want to continue or modify find....

I am trying to have this work on IWP... so it can't have the custom dialog boxes... and stuff like that.

Any help would be greatly appreciated

I would use a variable instead of a set field to set field.

Set Variable($DeptName; Holding::Deptname)

Then:

Enter Find Mode()

Set Field(ANNUALRPT::dept_name;$DeptName)

Perform Find()

Also, I don't use IWP so this is a question, can you run the script in IWP with debug on? If yes, that should isolate what the problem is.

HTH