Within our database we have the facility to either print or view invoices which are reports. The report is made up from a query filter selected from the current record in the form. We need to create a unique number for the invoices whenever a new invoice is created with that record in the form. In a way it is like an auto number in tables. The trouble is that all the records share the same report so each record does not have a unique report. The invoices are sent off at the same time.
I would be most grateful if anybody could help! (I will be amazed if anybody can understand what I want!!)
I would be most grateful if anybody could help! (I will be amazed if anybody can understand what I want!!)