Automatic relookup of field used in calculation
I have set up a calculation field that sums up several fields, a few of which are in the same file and a few of which are look-ups from another file. The file with the calculation field is entered first, then the file that is the source of the looked-up fields. The look-up fields show on the linked file, but the sum calculation does not include these fields. Is there a way I can automate a relookup of the look-up fields once they are entered, so that my calculation is correct?
Any assistance would be appreciated.