AnsweredAssumed Answered

CALCULATED FIELD doesn't work if related to more of ONE record.

Question asked by surfparadise on Jul 22, 2010
Latest reply on Jul 23, 2010 by LaRetta_1

Title

CALCULATED FIELD doesn't work if related to more of ONE record.

Post

Hi, I would calculate  in automatic a field... the function is this one:

**

If ( customer_table::address_type = "PT" ; customer_table::country_code ; "X" )

**

Calculated field name: Country_code in the table ORDERS.

Basically if in the field address_type is present the value PT.... the calculated field (contry_code) must take the value from customer_table::country_code.

The problem is that for each order I have 2 record related in customer table; one with the value AT and the other one with PT. 

The calculated field work well with this function: If ( customer_table::address_type = "AT" ; customer_table::coutry_code ; "X" ) but doesn't work when I search the value PT.... it is stop on the first record 'AT' (I think) and doesn't continue for find the other record (PT) ...and I have all the results with value X.

I think that there is a way to tell him to search in ALL related record...and not stop to the first that meet....

Could you help me please?.....

Thanks in advance!

Marco

Outcomes