CALCULATED FIELD doesn't work if related to more of ONE record.
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!