Best Way?

[Heathbo]

I have two fields. Field 1 and Field 2. I want them both to be calculation fields that check to see if the term "P-" shows up in the other field. If it does, I want the computer beep and display a message that says you can only have that term in one of the two fields. Then delete the contents of the last entered field. Is this possible? It sounds easy, but like many things it easier said than done.

Any Help you can give is much appreciated.

[Wim Decorte]

You can use a calculated validation on the fields to do this, sort of. Remember though that the validation depends on when the record is committed which may not be when you want it to happen.

Other than that, you need a event trigger plugin to do this.

[aaa]

I attached two files.

One - using Validations.

Second - using AotoEnter options.

I hope and will be glad if it help you.

Term_By_Validation.zip

Term.zip

Term_By_AutoEnter.zip

Term_By_Validation.zip

Edited October 11, 2005 by Guest

[Heathbo]

Thanks aaa, that helps a lot.

My question is, how do I get this to only search for P- and not duplicates of other words?

[Heathbo]

Any ideas?