Lookup table with select is missing values from User table

PHPMaker General Discussion (PHPMaker)
1

version 2026.7 / deleted cache

no filter on the select

I should select an Employee from the employee table in my User table. But when I open de drop down I miss the last 2 employees I added. I tries everything. ctrl+F5, cache deletion, closed browser, checked the database to be sure. But can not find any reason why I’m not seeing the employees.

2

If you have really cleared cache properly, all lookup options should be reloaded, you may want to check:

  1. You have cleared the correct cache for your environment (production or development), read Clearing Symfony Cache.
  2. Since it is the user table, if you have User ID Security enabled, note that the table is protected. The current user will not see all records from the user table unless the user has permissions. If you want to use user table as lookup table without User ID Security protection, you better create a view from the user table and use the view as lookup table.