I have a table tblrecordlog. I have a key field but also have a recordnumber in the format the client was using manually before for example 20139999. I have this number as a double now. The client would like to be able to add a record and a decision would later be made to possibly break up the project into multiple records. They want 20139999-1 for example. Do I set up another table? Do I to change the format of the field? Not each project will be divided. The -1 record would be independed of the original record or maybe I can delete the original record and have them all start out all records with -1.. I am not sure if I like that or not. Can someone give some insight. Thanks.