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" )

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".

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

=)

Sorry for not catching this earlier... the "&" in your first case needs to be "and" instead.

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

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.

thanks