Numbering Reports

[JustMaybe]

hi, can anyone please help??

1. I have a 'Order' form which gives a user the option to generate a 'Invoice' report. I would like an 'invoice number' that is sequencial and produced everytime this 'invoice' report is generated.

2. ideally this number would then be copied onto a field 'invoice ID' on the order form for later reference.

Any suggestions would be greatly appreciated
Thanks in advance

Sarah

 

[Rich]

Shouldn't the invoice number be generated at the time the order is created at form level, and then used in the report?

 

[JustMaybe]

No, because there is already a 'orderID' at form level. Not every order will generate an invoice. But for analysis reasons the invoice number should be unique form the orderID and the invoice numbers should be in sequence

 

[Rich]

Then how do you decide for which order an invoice will be produced, check box say?

 

[JustMaybe]

No the database won't be supporting orders on a large scale. The users simply press a button ...'print invoice' which generates the relevant report......

i suppose the invoice number should really be generated at the 'click' command??? (not that i have a clue!)

 

[JustMaybe]

obviously this button has to be pressed on the relevant record!!!

 

[Rich]

Your on the right track, search here for sequential numbers, there have been numerous solutions, DMax +1 is the easiest but only for simple numbering.

 

[JustMaybe]

dmax???? sorry...i'm not quite up there with you!!!

Just looked it up on help.....(proper novice)

And i think i kinda get it. Is there anyway you could give me a starting point on the kind of code i should be writing?