AnsweredAssumed Answered

Matching values

Question asked by Abhaya on Apr 7, 2011
Latest reply on Apr 7, 2011 by Abhaya


Matching values


Hello guys,

I want  to match a field value with  the values  already exist in that field.

Now i am explaining it

suppose  my field is f_text.

there are 3 records in the table for these 3 record corresponding f_text values are p,needs,fun.

my requirment is when a new record is created and if i typed fun it must show me error that value already exist but not show me error when a single charcter is typed like n,ne,f............

No doubt it can be done by navigating each record and compare exactly match with the field but i want to use function.

pattern count compare with the single character means when  one character  will match it shows error.

Just suggest me how to solve it.