>Hi Sir,
>
>How do I set my userid to AutoIncrement? I have just change my userid type from numeric to Integer. Please help.
>
>Thanks,
>Sam

It should be in a combobox with field types (closer to the end). However, I'm not sure you can change this for existing table. You may want to select your data into temp table, zap the original, change its structure and insert from temp. All of this after making a backup, of course.