1 Reply Latest reply on Feb 29, 2012 9:50 AM by philmodjunk

    New Records and Fields working with existing records

    SeamusDoone

      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.