Page 1 of 1
Problem Field Calculation
Posted:
Mon Dec 17, 2007 11:00 amby jim shelton
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" )
Posted:
Mon Dec 17, 2007 11:35 amby John Sindelar
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".
Posted:
Mon Dec 17, 2007 11:38 amby jim shelton
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
Posted:
Mon Dec 17, 2007 12:04 pmby John Sindelar
=)
Sorry for not catching this earlier... the "&" in your first case needs to be "and" instead.
problem Field Calculation
Posted:
Mon Dec 17, 2007 12:36 pmby jim shelton
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
Posted:
Mon Dec 17, 2007 12:40 pmby John Sindelar
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.
Posted:
Mon Dec 17, 2007 12:42 pmby jim shelton
thanks