I have a database which consists of two tables. The first is all the components and their data which the company i work for deals with. The second table is the customers details, invoices and delivery details. The two tables are interlinked with a field called job no which is unique in the second table and can appear numerous times in the first table.
I have produced a report which is a delivery note, and must be printed and sent with each invoice. The delivery note has a unique number to aid tracking, and as there can be more than one invoice to a customer I have delivery note 1 and delivery date 1, delivery note 2 and delivery date 2 etc up to 5 against each customer in the second table. I want to be able to auto-populate the delivery note with the delivery note number that corresponds to the days date as the report will always be produced the day the table is populated with the new delivery note numbers.
I think this will have to be coding but have no idea where to start.
Thank you in advance.