AnsweredAssumed Answered

New Records and Fields working with existing records

Question asked by SeamusDoone on Feb 29, 2012
Latest reply on Feb 29, 2012 by philmodjunk

Title

New Records and Fields working with existing records

Post

Hello,

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?

Example below:

Field A(existing)       Field 2(new)=Field A+Field B+Field C

Field B(existing)

Field C(existing)

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.

Outcomes