Hi Steve,

steve wrote:
Jake, before I implement this, I am already seeing a problem. if it
is a new project, it will find the max quote number, then add 1 to
it. if the max quote number is say, 5009.3, then the new quote
number would be 5010.3.

I have decided that this is probably not the best numbering scheme.
for that reason, i am going to keep the same quote number for the
same job, but use a seperate column as 'Rev Number'. i should be
able to alter your code to accomplish this.

That's what I would recommend anyway. Keeps things separate and easier to
manage. Good luck!

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]