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.