Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Validation on Phone Qualified Table

Hello,

Our main table is Customers and we have a Qualified table Phone.

We need to create a validation so that if the County (non qualifer) of the Phone table = US, then the length of the complete phone number (qualifier) field must have a lenght equal to10.

I am writing the Validation against the main table Customers.

I tried these two and neither work. I get a valdation error if the Country = US and the complete number = 10. I get a validation error if the counyty does not equal US.

IF(Phone.Country.[Record]= Countries[Unites States],LEN(Phone.Complete No.)=10)

IF(Phone.Country.[Record]= Countries[Unites States],LEN(Phone.Complete No.)=10,FALSE)

If I do indiviual validations on Country and Complete phone length, then the validation works but i need the combined validation.

Any suggestions?

thanks

Tammi

Tags:

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question