Creating an invoice number

[Bentleybelle]

I have created an invoice. There may be several lines on an invoice. Each line item generates a log number in the underlying table, but obviously I want only one invoice number and I want Access to generate that number consecutively. I feel this should be (relatively) simple, yet I just happened to see a similar question on another forum and the experts suggested using FileMakerPro. But I don't believe Access can't handle this. Any suggestions please - thanks.

 

[ByteMyzer]

You are quite correct; Access is capable of handling this, and there are several methods of so doing, depending on the database architecture. Will this be a single-user or a multi-user application, front-end/back-end split? Would it be possible for you to post an attachment of your work so far?

 

[tickes]

invoice header table

once you create the invoice header table, do you create this in your report by making it a sub-report? And how do you save this invoice??