I am also having a problem with numbering. I know this is a simple question, but I cant hit upon the right answer. I have inherited a database that the employee id SHOULD HAVE BEEN an autonumber, but was not. Now, the table will not let me change to an autonumber (has many, many records and the employee id is now the primary key in other tables)...I have created a form to input the data, but I need it to automatically look at the last number in the table and put in next number in sequence.