Problem Field Calculation

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Dec 17, 2007 11:00 am
The following is the calculation for a field. It works well except when the first option is met, then it answers like the fourth option is met.

thanks in advance.

JIMBO



Case (
Perso Only = "Yes" & Customer::Company = " Teraco"; "Teraco Perso Only";
Job Ticket 3::Job Status = "On Hold"; "On Hold";
Gang Run = "YES"; "Gang Run";
Perso Only = "Yes" ; "Perso Only";
Outsource Type = "collateral print" ; "Outsource" ;
Outsource Type = "card print" ; "Outsource" ; "In House" )
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Dec 17, 2007 11:35 am
Sounds like this part of the first option isn't being met...

Customer::Company = " Teraco"

...perhaps because of the space in front of the "T".
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Dec 17, 2007 11:38 am
I found _Teraco and Teraco. Neither worked. I have corrected _Teraco. Does not even work with other companies.

This is my relationship between tables. Has not been problem till now.

Customer::__kp_CustomerID = Order::_kf_CustomerID

Allow creation checked on both sides.

Jimbo
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Dec 17, 2007 12:04 pm
=)

Sorry for not catching this earlier... the "&" in your first case needs to be "and" instead.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Dec 17, 2007 12:36 pm
Okay that helped. It works for other accounts but not Teraco. There are several customers named Teraco. Each has a different Account ID number.

Would that make it not work?

Jimbo
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon Dec 17, 2007 12:40 pm
Couldn't say without seeing the data / files Jim. Sorry. In cases like this I usually place the fields in question on a layout...

Customer::Company

...so I can see what's happening.
John Sindelar
SeedCode
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Mon Dec 17, 2007 12:42 pm
thanks
JIMBO

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: