OrderNumber, Invoice Number, Credit Number

[Simon]

I am currently building ordering database for my business. I am
currenlty use 1, 2, 3 ect for OrderNumbers Invoice Number and Credit
Numbers
To genetate the number i am using the following code on the Deafual
setting of the field on the form

CLng(Nz(DMax("OrderNumber","tblOrder"),0))+1


This works fine . I have been thingking that i will be having a lot of
number and it might get confusing if they are order number, invoice
numbers ect

i was thinkinking of somthing like OR0001 for OrderNumber, IN0001 for
invoice Number and CR0001 for Credit Number

This way i will under stand the number easier when dealing with
customers

Is there a way to do this, or can any onesurgest a way to do it.

thanks

 

[Graham Mandeno]

Hi Simon

Don't store the prefix as part of the number. Rather, just add it to the
number when it is displayed on a form or printed in a report.

For example, on your "print an order" report, you could set the Format
property of the OrderNumber textbox to:
"OR"0000

Or you could explicitly set its ControlSource to:
=Format([OrderNumber], "\O\R0000")