Create empty rows

[kirret]

Hi.

Is it possible to create a certain number of empty rows inside a database automatically and then make the first row active again that you can start typing in to that box.
I'm working on an invoicing database. The problem I have found is that when I enter data inside the main information box (parts and materials) it makes only as many rows in Invoice report as many I had them while entering information. What I need to get is when I start a new invoice, a certain number of rows are created automatically inside Parts and Materials and Labour boxes and they will show up then in Invoice report.
I have added file 1.zip (data entry, Invoice report at the moment and Invoice report as it should be ideally). Is it possible?

Regards,

Kirret

 

[RuralGuy]

Someone else might have a better solution but the only way I've seen this handled successfully is with a temporary table where you add in the complimentary blank records to get the length you need.