Reprint invoices with original number

[liltechy]

I am in the process of creating a database where I will be printing invoices. There will be times when I will need to reprint an invoice with the original invoice number. Using autonumber will not allow me to do this. How can I accomplish this?

liltechy

 

[psemianonymous]

I'm not with you on two things here:
1. Don't use an autonumber if you need everything sequential. Autonumbers can and do skip numbers if there are deletions. Instead generate your own invoice number. There are other threads on generating a primary key.
2. What happens to an invoice once it is entered? How do you print an invoice in the first place? If you use a report, then you may easily filter the data source for the report to any invoice, past or present, as long as the data is all there. Explain.

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[liltechy]

foolio12,
Since you don't recommend using autonumber, then what do you suggest.

liltechy