New Records and Fields working with existing records
I have a large database containing close to 2,000 records. I am currently adding a new tab and new fields to the database. Some of the new fields I am making contain calculations that involve existing fields. Is there a way of making this work with existing fields and records so that when I import/update data within the database these calculations are taking place?
Field A(existing) Field 2(new)=Field A+Field B+Field C
I have done this but it only works when I create new records. I want it to work with existing records and to update everytime I import new data. Any help is greatly appreciated.
Make Field 2 a calculation field instead of a data field with an auto-entered calculation. Then all records will update to compute a value in the field when it is added.
There are also ways to get existing records to update when an auto-entered calculation must be used: