Using a linked column as part of a formula


#1

I have a “Rates” table that I am linking into a column on an “Estimator” table. It seems as though I can’t use the linked-in Rate data in a formula on the Estimator table. Is that right??


#2

You have to create a lookup field on Estimator that points to the field in the Rates table that has the data.

From there, reference that lookup field in your formula.