I have a database here that I'm re-building to make it more up to date for my customer. They need a Quote table, form, report, etc.
Their quote numbers are generated as "2008-000"
2008 being for the year, and 000 goes as the automated number, for each individual quote.
This is a tricky one for me. I'm thinking the best way to set this up would be as two different fields, since they are two different criteria bases.
For "2008" what code, setup, etc could I use to make this transition on it's own come the begining of 2009, 2010, etc? This isn't something I'm familiar with.
for "000" I'd need to input an initial starting value of where they are at, and then it would need to generate the numbers from there. Seem to have problems pulling up an area to insert an initial value.
If anyone has any idea of a briliant or at least workable set up for this, I'd appreciate the input!