This is a weird one, but I’ll do my best to explain it, using servoy 4.1
I have a form from Table A, there is a tab on this form that uses a relationship. The relationship is a self join to Table A. The relationship uses a foreign key field on both sides and a global equal to a single character “O” on the left hand side and a field that may be equal to “O” on the right hand side.
On the tab you can run a method that will change an existing Table A record so that that field is equal to “O” whereas previously it wasn’t. However, sometimes that changed record will not show up in the tab after the method is complete. Not only that, but leaving the form and coming back to it still doesn’t display the record. We’ve even tried databaseManager.saveData() and application.updateUI() and various explicit loadRecords() attmepts. The only was to get that record to show up on the tab is to logout and login again. Looking at the back end data even shows that the data changes are being committed before logging out but the relationship refuses to acknowledge that it has an additional related record. Testing : relationshipName.getSize() returns 2 when there should be 3 based on this change.
It’s as if the realationship needs to be refreshed like calculations need to be recalculated sometimes, but there’s nothing I know of that would effectively refresh a relationship. And what is it about logging out and logging in that does refresh this relationship?
Any help is greatly appreciated.