A new row does not appear in the lookup form

0 votes

We have a table that provides lookup values. When the user addeds a new entry they click the box and the rows of the table are displayed for selection. Very standard. We added a new row to add a new selectable option and the new row will not appear in the lookup. I have tried looking at the base table and it does show the new entry but it does not appear in the dropdown. I have also tried turning caching off on the table but still nothing.

is there a way force a refresh of the lookup table?

in Version 1.2 by (150 points)

1 Answer

0 votes

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.

Disable Caching

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:

  1. Disable Server Lookup, and
  2. Change the table caching type.

For more details see:

by (64.5k points)
edited by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer