Table Validation rules.

[tperez86]

What expression can use for this validation rule if I have 2 fields called firstname and lastname and cannot be same
Make sure the Customer’s First name is not identical to the Last name?

I tried everything can't seem to getting right:banghead:

 

[pbaldy]

Not sure it can be done with a validation rule. I'd use this:

http://www.baldyweb.com/BeforeUpdate.htm

 

[Frothingslosh]

Out of curiosity, why can the first name not be the same as the last name? At a previous job, we had several employees actually named Mohammad Mohammad.

 

[ButtonMoon]

What expression can use for this validation rule if I have 2 fields called firstname and lastname and cannot be same
Make sure the Customer’s First name is not identical to the Last name?

You can do that as a table validation rule (AKA check constraint):

[FirstName]<>[LastName]

It does seem a bit unlikely to be a useful rule though. I expect there are people who genuinely have the same name for first and last name.