MDM Data Manager Expressions / Validation Help

75 Views

Hello.

I am trying to create some validations that are not working. I am trying to create a validation that when a user creates a new customer, if the country is US, than the company code must be 1001.

This is the validation I created: Country.Code="US"=Company Code Data.Company Code.Code="1001"

I do not get an error message when creating this. But when I go to test it, and enter a customer with Company Code 1001, I still get my error message.

When I select my Qualified Lookup Table from Company Code Data, I do not see just 1001 from the drop down list. I see "DB, Inc., 1001" (which is obviously the code AND the name combined).

I only specified code in my validation...but even when I change the validation to: Country.Code="US"=Company Code Data.Company Code.Code="DB, Inc., 1001" I STILL get the error message!

Help! : )

I will definatley award points for helping!

Nichole