AnsweredAssumed Answered

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

Question asked by henryoswald on Jan 12, 2010
Latest reply on Jan 12, 2010 by 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?








Outcomes