2 Replies Latest reply on Jan 21, 2015 6:04 PM by amtrakpdx

    Value List question



      Value List question


      Dear Wizards,

      I have Tbl ‘A’ and a TO of Tbl ‘A’ I’m calling Tbl ‘B’.  The Tbl has Field1 that has unique values but will also have a lot of empty (null) values.  I want a Value List created that uses only the non-null values.  I know how to write the script that would make Tbl B have all of the non-null values but is there some sort of a method (script trigger?, other?) that will cause a ‘fresh’ Tbl B to ‘exist’ when the Value List for that Tbl is addressed?
      Again, Thanks for your help