Invoice line items: Repeating field vs. line item table
I developed an invoicing system for my business 25 years ago when FM was only on the Mac and was not relational. It uses a repeating field of 10 lines for invoice line items. Occasionally I need more than that and have to make separate invoices.
I noticed that nowadays, samples of invoice databases from FM and others use a separate table for line items with a portal on the invoice layout. Other than the ability to have unlimited line items, what are the advantages of doing it this way?
Thanks in advance for any advice.