Value List question
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