cancel
Showing results for 
Search instead for 
Did you mean: 

MDM Data Manager Expressions / Validation Help

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Firstly you havnt elaborated your problem fully anyways...

I am assuming Main table having field Country which is looking into the lookup table Countries and having field say Code

Company Code Data is field in main table which is look up to qualified table (say Qualified country) which contains field Company Code as either (Qualifier or non-qualifier) and this Company code is further lookup to some table say Codes having field name as code .

IF(FIND(Country.Code, "US"), Company Code Data.Company Code.code = "1001", FALSE)

IT SHOULD WORK.....

Thanks,

Mandeep Saini

Edited by: Mandeep Saini on Jul 31, 2008 5:31 PM

Former Member
0 Kudos

This also comes up with a syntax error when I try to copy / paste it in to the validation expression field. I appreciate you trying...

Former Member
0 Kudos

I'm sorry I spoke too soon, I just had to delete the country.code and company.code.code and replace them with the fields from the drop down box instead of writing them in by hand. It worked! Thank you so much I appreciate it!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Nichole,

Check the below expression

IF(Country. = Countries , Company Code Data.Company Code. = Codes {DB, Inc., 1001})

Assumptions:

1.Country is a main table lookup field that is looking into the lookup table Countries

2. Company Code Data is a qualified table which contains Company Code as a lookup field which is looking into table Codes.

Regards,

Jitesh Talreja

Former Member
0 Kudos

Unfortunaltey that came up with a Syntax error. Thanks for trying!