Help Please (1 Viewer)

[Kloust123]

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

 

[NeutronFlux]

When you say all the records show up in 1 invoice sheet, are you using a report and printing? If so, try adding in a page break to your report design.

 

[spikepl]

... and also sprinkle some line breaks in your text . :-D

 

[Kloust123]

Lol sorry i am new to this, page breaks - how? am i missing something lol

And yes text breaks too how do i go about both? bet its something ive overlooked haha