Paradox Duplicates

[rgeinosky]

I have a table set up with SS# as the key field. I have been asked to add a field called Control#. The entry clerk will enter the Control#. I would like to establish a Validity Check to test for duplicates. I cannot see how to do this. Is there a way using a MethodAction such as "Departfield" or something similiar that will test for duplicates in that field. I cannot make this a "Key" field.

 

[Guest_imported]

Best place to do this is in the CanDepart method. I will require you to scan the ENTIRE table to ensure that the value is not already present. If it is, then prevent departure using an error code. See below : <fieldName> is the actual fieldname in the table / form.

method CanDepart(var.....)
var
tc tcursor
endVar
tc.attach(self) ;if this won't work, attach to the fieldName
if tc.locate(&quot;<fieldName>&quot;, self.value) then
eventInfo.setErrorCode(CanNotDepart) ; CanNotDepart is non zero constant
endif
endMethod

 

[Guest_imported]

I will attempt this and let you know how it works out
Thanks
Bob