Validation Rule

[jmriddic]

Question about validation rules. I have a user who has set up a validation rule to allow certain values to be entered.

Something like if the value equals 4 or equals 5 then it would accept it. Now she would like the validation be set so they can put both 4 and 5 in together. How can this be done?

 

[KenHigg]

Is the fld in question a number or a string data type?

kh

 

[jmriddic]

Its String

Its String.

 

[KenHigg]

Hum... Not know how the 4 and 5 could occur in the string, I would say:

Like "* 4 *" Or Like "* 5 *"

kh

 

[jmriddic]

Actually

Ken,

Actually its words but what if I need to seperate by commas. Thanks for the help.

 

[jmriddic]

Can someone help me

I have not hear back from Ken. Can someone else help me. I need to know how to do commas in the validation rule as mentioned before.

 

[suvlaki]

could you post a 'sample'

message of what you are after?

 

[Mile-O]

Stop there. You are making your data non-atomic which goes against the very first rule of database normalisation. Do some reading on normalisation.