Calculation using realtionship doesn't update untill I modify database/close system
Hello, I've got a strange problem which I’m not sure how to fix.
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
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?