2 Replies Latest reply on Jan 12, 2010 9:03 AM by henryoswald

    Calculation using realtionship doesn't update untill I modify database/close system

    henryoswald

      Title

      Calculation using realtionship doesn't update untill I modify database/close system

      Post

      Hello, I've got a strange problem which I’m not sure how to fix.

      Table 1:

      list of IDs field - this is a calculation field which holds a list of ID's from table 2 (it uses a different table occurrence of table 2)
      Names of ID - this is a calculation which pulls through Table 2:Names

      Table 2:

      ID's
      Names

      The relationship is - Table 1:Repeating ID field = Table 2:ID's

      The problem is that the field "Names of ID" doesn't update automatically in line with the field "Repeating ID field" it will however update if I make a modification to the database (relationship graph etc) or I close and open the database.

      Anyone know what I’m doing wrong?