A database named “A” with a field ID contains other fields which have a relation to corresponding fields in another db named “B”, i. e. their values in “A” need to be looked up in “B” from the records with the same ID there. I found that this is NOT always done automatically, when I expected it, e. g.
- when importing records into “A” with only the set of fields filled, which need not bee looked up in “B”
- when creating a new record in “A”, to which a new ID is automatically assigned
The only way for updating I found is to execute “Field --> Morph --> Recalculate Field” for every affected field, which is a bit cumbersome when there are several.
Would it not make sense to maybe at least offer some “recalculate field” button in the field properties panel, or a context menu to recalculate an entire record at once, or even the entire database?