Two tables have a relationship based on following condition.
A::value1 > B::value2
A::value1 <= B::value2
And I have one field, fieldA, of A, and that field is updated with the a field, fieldB, of B which is selected by above condition.
But, if I change the A::value1 to read another record, it does not automatically change the record.
That is still showing the old one. So fieldA has the old value.
How could I make the app read the record based on updated condition?