Selecting number of repetitions used for display and printing
I have an invoice database, which is created with a maximum number of 40 repetitions for each field (quantity, product number, item name, price, etc), How can I select the number of repetitions I want for each invoice when it is printed to eliminate the excess blank lines.
For example, invoice #101 might need 8 repetitions and invoice #102 might need 20, but I want keep the maximum number of repetitions at 40 to cover large invoices.
Also, when the page reconfigures with the selected number of repeating lines, will the totaling information at the bottom of the page move up when lines are omitted or hidden? Will the print format expand to 2 pages if needed?
I would suggest replacing the repeating fields with a related table of line items where each related record takes the place of one repetition. A list view layout based on this related table can then be used for printing your invoice and this will automatically adjust for any number of items listed on your invoice.