I have a table called: ENG_DB
It has fields called: quote_id
I'm trying to keep track of a quote number.
The quote number works like this:
QXXX = the quote number which is ascending, changes with every different quote (in order) (ex. Q001 through Q020,etc.)
Z = is the quote revision (which is always associated with its quote number) (ex. Q001.1,Q001.2, does not equal Q002.1)
yy = the year the project is quoted
mm = the month the project is quotes
xx = the number of the project (there could be 4 projects for 1 quote)(ex. Q001.0-05.04-01.0, Q001.0-05.04-02.0) <---this is two projects
z = the revision of the project (same rules as the other instances)
...The dashes and decimals are just for saving the file or creating the folders representation purposes only (need to be included but not in database)...I think :)
I need a string that would combine all this into a usable representation of the file or folder and have the ability to create the folder when needed.
I'm using a SQL database with VB6 or VB.NET