Invoice Numbering

[Gatorjunkie]

I am trying to tweak the Desktop Time and Billing template to fit more of my needs. I have been able to accomplish the majority of changes that I need but am stuck on a few.
1. Generate automatic invoice number on invoice report
---- I have added an InvoiceNumber and a BeenInvoiced fields to the Project Hours and Project Expenses tables.
Goal:


When I click on the "Print Invoice" button I want it to generate a number and populate that number to the corresponding Project Hours or Project Expenses line items. This is so that in the future I can put in the ability to print previous invoices.
Prior to the invoice report running I want it to only put on the line items that have no invoice number associated with them. This way when I add more line items to the project it will not invoice the customer more than once.

Thank you in advanced

[June7]

Generating custom unique identifier is common topic in forum. Search forum. Start with https://www.accessforums.net/forms/e...lue-40852.html