hy, sorry by my english !
i have 1 table with ID in autonumeric, and CODE in text, CODE has a mask "CRI - ", so what i need to do is concatenate "CRI - " & ID, so it will return “CRI - 1” and it increase in every new record!
please sombody can help me !