There should not be any get function at all used.
The correct syntax for ValueListItems, as documented in FileMaker help is:
ValueListItems ( "fileNameofYourDatabasefileHere" ; "NameOfYourValueListHere" )
This is often set up like this:
ValueListItems ( Get ( FileName ) ; "NameOfYourValueListHere" )
So that renaming your database file will not keep this function from returning a list of values.
And your method for listing unique values will only work if you have correctly set up a conditional value list that references the correct sub set of values.
I see what you mean by that conditional value list because I fixed the ValueListItems **I didn't know FileName was to be left "as is"*** and when I made a new record the calculated field came back as 8000,8001,8003 all in one box! Should I change the way my value list is setup?
I mean HOW do make it a conditional value list? I kind of thought it already was one.
Actually I just looked it up and I know how to do it I just didn't know the term! Is there a way I can add my value list to reference the sub set of values?