cross-ref calculated field
I have x-ref calculated field in my app. It is working fine and picking the correct values. But when the related field gets updated, the calculated x-ref is not getting updated.
I was just getting ready to post something similar. Is there a good way to force calculated cross references to recalculate? I have replaced a data feed to inherit controls with a calculated cross reference but sometimes some just don't calculate. I have to remove the selection for the value that is the filter, save the record, and then readd it in order for it to recalculate.
Do you mean the related reference field or a field that the calculated reference field is dependent on?
You can confirm that the field the calculated field depends on in the table tblCalcField.
SELECT * FROM dbo.tblCalcField cf
AND cf.field_id = 0 --Calculated reference field
AND cf.formula_field_id = 0 --Field that calc depends on
Modifying the field should cause a calculation. If it is not please open a support case to dig in deeper.