>Is there any way that I can sum numbers to another number.. but as a character field?
>
>Because i have a routine that sums +1 to the last record of the database... but that record is a character field.. and i cant change it to numeric...? some help plz...
>
>Okay the real problem... is .. that i have a combo box wich lists new customers... those customers are in a table wich has a *customer_id and customer_name, but... i want the user of my program to add new customers... so they will appear in the combo box for later selection... the problem is that i want to relate the customer table with my main table... when I add the whole record i have data type mistmatchs in the combo box :'(

You can use STR() function to convert numeric to character.