Preventing Duplicates

[CharlesC]

Hello,

I've solved a problem here before, and it helped my learning, so here goes:

I want to validate a field called "Title" so as to prevent duplicates of that field unless a particular value in another field called "Actions" is set to value 'Out'

I have a vague sense of the syntax

IF "Actions ≠ Out" AND "Title = !!" THEN "Duplicates are Not Allowed."

I also want some way to prevent the creation of these duplicates.

Any help would be much appreciated.

Edited December 1, 2005 by Guest