I have a table that holds course dates and times. There is an ID coulmn in that table which was originally an autonumber. The ID is the primary key for the table. When I was upgrading a part of the database, I had to remove the automnumber designation from the ID column and changed it to "number". Little did I know, that you cannot change a field with data in it back to autonumber. My thought on this was is there some way to set the default value of a new record to the max "ID" +1 or if anyone knows how I can reinstate the autonumber with keeping the exisitng ID values that would work also.
thanks
mrk
thanks
mrk