4 Replies Latest reply on Oct 13, 2016 4:15 PM by LoriE

    copy value only from a calculation field

    LoriE

      I am working on a Meetings database with tables: MeetingDetails, Minutes, Actions

       

      I have a field that calculates the item number which is a combination of Meeting# and minute#. Works great. The problem I am having is when I create a new meeting site, go find the incomplete minutes, duplicate them and add them to the new meeting.... I want the item# that was calculated to remain the same. But as I have it now the item number changes when I change the meeting number.

       

      The item Field is set up as a calculation field and the calculation is simply (MeetingDetails::Meeting#) + ( Minute#) and minute number is from the minutes table.

       

      Is it possible to set the calculated value in my script before it changes the meeting number. that way the item number would be set as a value.

       

      So.....

      Meeting#1

      Minute# .01

      =   Item# 1.01  New business

       

      Then when:

       

      Meeting#2

      Minute .01 from meeting# 1

      =    Item# 1.01   Previous business ( I want the item number from meeting# 1 to remain the same through all subsequent meeting until it is no longer incomplete.

       

      Any ideas?