AnsweredAssumed Answered

Table Based Value List Not Displaying New Records

Question asked by johnhorner on Mar 29, 2012
Latest reply on Mar 29, 2012 by johnhorner


Table Based Value List Not Displaying New Records


i have a table used only for generating a value list of product categories.  there is only 1 table occurrence for this table.  i created a value list based on this table and have attached a screenshot to show how it is configured.

the problem that i am having is that even with commit record and refresh window steps in the script that allows users to create new product categories, it will not show new entries (even after closing and re-opening the file).  nor does it work to select "refresh window" from the menu or keyboard shortcut.

the only way that i have discovered to make the newly created records visible in the value list (drop down list or pop up menu) is to go to a layout based on the product category table where i have a drag and drop sort capability.  if i use this and go back to the layout where the pop up menu is, it shows all the records.  however, if i just use "sort" to re-sort the records, it has no effect.

if it helps at all to figure it out, i have an almost identical set up for invoice categories.  the only difference that i can tell is that the layout where users add new categories has a portal (self join to all invoice categories) instead of showing the records in list view.  but the value list is set up the same as for the product categories meaning on the "main" t.o. and not the self-join used for the portal.   for some reason this value list works fine?

any thoughts???