numbering list ?

[fibayne]

Hi
I have a purchase order database that I also create customer invoices from, each line of a particular order can have either the same or a differant invoice number.
Within the DB there are 4 types of media billable all of which I would like to use the same numbering system ie SI00001 onwards
but i cant get my head round how to do this allowing the number to be used more than once on an individual order but not on more than one order.

does anyone have any pointer similar situations

thanks in advance for any help

 

[Epic]

will this do ?:
InvNo = "SI" & YourAutoNumber

 

[fibayne]

numbering list

Hi Epic
thanks for your reply, I dont think this will work for me though as if I were to use the POrderID auto number I would not be able to give each line of the POrder ( the 2 tables in use are POrder and POrderDetail) an individual inv number ie no matter when the individual line of the order were billed it would have the same inv number and if I were to use the POrderDetailID autonumber I could not give more than one line on the order the same inv number.

I guess there is code that could do this but I am not up to working this out...

Any more help would be appreciated with this.