ideas for data validation script
I am looking for ideas on how to implement this bit of data validation. Assume you have 3 fields. Lets call them X, Y, and Z. Field X contains user entered data. If field Y = true and field Z = true the data in field X must be unique. I have several ideas, but they all seam pretty clunky.