... Two questions... a) is there anyway at all export and import custom defined values within a value list? ... as much as i'd like to create a table for each list, i dont really want to... : is there anyway to generate a value list by script?

Cheers for help, suggestions etc. Genx

a)

Export - Create an unstored calc field using the ValueListItems function, look it up in the help file, then export the field contents of the new calc field. Of course the results may not be perfect considering you don't actually get a return delimited list, you get a list with either a CR or LF only (can't remember which). This may or may not be an issue with the program you will try to later import the list into.

Import - not that I am aware of other than Copy and Paste.

: Yes, if you are talking about a Value List from a field but No if you are talking about a custom defined Value List (unless things have changed in this respect for V8, which I doubt).

What do you have against having the value lists in another table?

... the fact that there's about 50 or so value lists... each with five or six varying values... im not sure i would want to waste my time on it...

hmmm... on second thoughts i will use tables... ill just make 2 tables... one to store the names of the value lists in individual global fields... and the second to be related each seperate individual global field thereby sort of creating the value lists... then assuming that actual value lists dont get deleted... i wont have to use custom defined values at all :... yay for me