Hi im creating a database for a local mechanical garage, most of it is setup but i have an issue creating invoices, I need to create a button on a form which will create an invoice per record. Trouble im having is if i have 1 record it will show just 1, but when i add multiple records they all show on 1 invoice sheet. It doesnt separate records, i but instead it adds the extra records before the page footer :/ causing 1 footer for many records. If anyone can help please finish the functionality of this DB, i can certainly finish the design side. Everything in this DB is set accordingly, just the invoice system to do i believe, could some1 have a look and let me know? i have tried to upload it here but cant so its on this link https://mega.co.nz/#!CcJk0YTB!Wwl-60...bc16NE33jveUHQ