4 Replies Latest reply on Apr 6, 2017 8:06 AM by DragonDave

    Problem with value list from field not updating immediately


      Hi. I've got an odd little problem I'm not sure how to correct.


      I have the starts of a simple DB with just a few tables. Something like this:

      Image 1.jpeg


      There's a layout for the BUDGET table that has a couple of portals. One is a portal that allows me to create new CATEGORY records. There's another portal that shows ITEMS. Part of the ITEMS portal has a field that shows which CATAGORY the ITEM is associated with. It's a pop-up menu tied to a value list tied to the budget_item_CATEGORY TO.


      Here's the problem. If I go to the category portal and add some records, then immediately go to the portal that shows items, and I click on the field to display the possible category records, it doesn't show the updated records, at least not immediately, If I wait a couple of minutes, or I restart FileMaker, then it shows the correct values.


      Any thoughts on how I would force it to update the value list immediately?


      Here's my workaround. If I change the relationship to the following...

      Image 2.jpeg

      Then the result is better. Changes to the category table are reflected immediately in the value list when I select the category field in the item portal.