We have tables, some with views that need to load a fresh copy of the data every time the user uses them in a lookup or elsewhere.
The issue is that we update these tables externally and dbFront does not recognize the updates because sometimes it is working with cached data. This shows up in multiple places:
- When using fields from the Profile Table in the page headers,
- When using dropdowns/lookups,
- When editing other records on the same table grid.
It would be great if we could force dbFront to always load fresh data for these tables.