Microsoft Access 2010 Add a -1 to 20130001 now may be 20130001-1
Posted on 2013-11-30
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.