Global Value List?

[Anuviel]

What would be the best way to create a global? value list?

Basically I have a field which will contain same set of values always.

The values that can be chosen for the field are:

1, 2, 3, 4, 5 and 10

1 = Brand New

2 = Used-Like New

and so on.

Should I create a preference table with 12 fields containing the mentioned values and relate that table via fKey to the actual data table and then have the value list get values that way or is there a better, more standard way to do this?

I could use a value list with custom values of 1, 2 and so on but I want the user to see

1 - Brand New

when they click on the field. After the selection is made the field should have 1 in it only.

Hope it makes sense.

Thanks.,

[mr_vodka]

Why not just store the values in a new table?

[Anuviel]

Thanks, it seems I will do it that way. I was just wondering if there was a different or better way.

Thank you.,

[EllenG]

You can create a custom values list and then just take Leftwords(value,1) to pull in just the number.