Let me try this again.
Category Type is a Text Field with the three categories HW, SW and SR. Once the user selects either HW, SW or SR for this field, the calculated Invoice # should be filled in automatically by the calculation below.
I have a field called calculated Invoice # set up as a Number with the option to auto enter a calculation. The calculation is as follows:
Case(Category Type="HW" ,Right(DateToText(Date),2)&"01"&HWNUM,Category Type="SW",Right(DateToText(Date),2)&"02"&SWNUM, Category Type="SR",Right(DateToText(Date),2)&"03"&SRNUM )
The HWNUM, SWNUM and SRNUM are set up as number fields with the option of auto entering a serial number starting at 100 (this is where I made an error in my previous example). The problem is that every new record, all three numbers increase. I only want the corresponding number to increase. If I enter a hardware invoce, I want the HWNUM to increase by 1 and SWNUM and SRNUM to stay what they were... Hopefully I have explained it better this time.
Thanks,