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

    Problem with value list from field not updating immediately

    DragonDave

      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.

       

       

      Thanks!