Hi, i'm trying to set up an Auto-Enter Serial number on a field, and my problem is i want it to have a different format depending on which value i choose in an other field (with value list DV, PV, ST, AUDIT)

I tried to do a little calculation but it obviously didn't work...

Do i need to set a calculation and still have the Auto-Enter Serial number ticked??

Any help would be much apreciated!!

THANKS !!

Is it just simply the formatting that needs to change or are there different sets of serial numbers ( adifferent set for each value of the second field)?

TougToug, yes, you need an Auto-Enter calculation, not the serial number method.

Ok let me clarify a little bit:

i have "Report ID" (where i want the serial number in) and "Design Level" where i chosse the value.

what i would like to do is when i choose from the drop down list in "Design Level" the value "DV", the calculation put the next serial number of format DVxxx and if i choose "PV" => PVxxx, etc...

I tried to use something like

Case(Table::Design Level = "DV" ; Get(nextserialnumber)... but then how do i put it the "Report ID" field???

Any suggestions would be much appreciated

Concatenate the two.

Thanks great idea

that was not what i had in my mind but there is no problem doing it that way and it's a lot easier