Validation on Phone Qualified Table
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.