To Cache or not to Cache, that is the question.
This issue is because dbFront attempts to use caching to improve the application responsiveness.
Therefore all lookup results are only refreshed if dbFront recognizes an update from within dbFront, or at the database (very slow), or periodically.
If you know that a table will receive regular updates outside dbFront, then the best solution is to disable the caching.
There are two methods:
- Disable Server Lookup, and
- Change the table caching type.
For more details see: https://dbfront.com/qa/1012/force-dbfront-to-load-a-fresh-copy-of-the-data-everytime