auto-serial and value list

[chaletart]

ok...noob here....

I like to select an item from the value list and have it auto serial. I got that part done, but I would like to to number consecutively to each item chosen from the value list, i.e.

MDV-001

DV-001

then...

MDV-002

and so on..

thanks!

hope someone can help!

cheers

[Søren Dyhr]

Try with:

GetValue ( ValueListItems ( Get ( FileName ) ; "theList" ) ; RecordID )

Where "theList" in quotes should be the name of your valuelist!

--sd

[chaletart]

ok, it is pulling from the value list but not what I select.... it is pulling the first item in the list...

I know I am missing something really basic.

Thanks for the help!

[Søren Dyhr]

it is pulling from the value list but not what I select

You - not the autoentered value?? You could have any numeric field at RecordID's place in the calc, let it be the field you enter a number in.... make sure to use the right kind of field types!

--sd