on 07-30-2008 10:22 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.