Hello,
I need to create a simple database that will keep track of the latest version of a document we are using. For some reason, I cannot decide the best way to do this. All I need to track is the Document number, document name, date, version number, and system number.
Ex: document number - ABC, Document name - : Document A, Date - 01/01/2013, Version - 0001, System Number - MR444
How can I create a simple database that will locate if there is a previous document under the same number, and if so, have an easy way for a user to add the next version number. For example, with the above information, do a search on document number ABC, see there is a version 001 already created, and add the information (to link to the above information): Date - 03/01/2013, Version - 0002, System Number MR555?
Any ideas would be appreciated.
I need to create a simple database that will keep track of the latest version of a document we are using. For some reason, I cannot decide the best way to do this. All I need to track is the Document number, document name, date, version number, and system number.
Ex: document number - ABC, Document name - : Document A, Date - 01/01/2013, Version - 0001, System Number - MR444
How can I create a simple database that will locate if there is a previous document under the same number, and if so, have an easy way for a user to add the next version number. For example, with the above information, do a search on document number ABC, see there is a version 001 already created, and add the information (to link to the above information): Date - 03/01/2013, Version - 0002, System Number MR555?
Any ideas would be appreciated.
