Long time for value list updates?
So I have a customer contacts table and associated layout for customer contact information data entry. Works great. No issues.
In our Jobs table/layout, I use a pop up value list based off a customer contact field (a calculated field to add company name and contact name together, aka Jim's Company - Jim Moore) in order to input the correct customer ID into the FK field for the Jobs table. I've noticed that if I go to the Customers layout, make a couple of changes (perhaps to company or contact name) and try to select them in the value list pop up, that the contact info isn't there. It doesn't happen all the time, but it does happen at least 50% of the time. However, if I close my session, re-open the DB and login, the info is updated in the popup/value list and I can go on my merry way.
Is there any settings I can mess with in order to ensure that any of my value list pop ups (of which I have at least 4 or 5) update fast fast as possible for my users?