I already had a program that has an auto-generated ID . I used a textbox and whenever I click the new button I use this commands:

    LOCAL liMatic

     liMatic = TableName.Idno + 1

     APPEND BLANK

     ThisForm.txtIdNo.Value = liMatic

     ThisForm.Refresh()

This commands does work to automatically generate an ID number with an Integer Value. My problem right now is that I used a combo box and the ID number was change to character value because I need to have an ID like RL0001 , RL0002 , RM0001. In my form there are two combo boxes. the 1st is for the ID and the 2nd is for choosing whether it is a ROLL or a REAM. If I choose ROLL then Save I must have an ID number of RL0001. Its hard to generate an auto-generated ID using a combo box and as a character value. Can u please sirs help me with this problem? thank you so much .