AnsweredAssumed Answered

Value List question

Question asked by amtrakpdx on Jan 21, 2015
Latest reply on Jan 21, 2015 by amtrakpdx


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