6 Replies Latest reply on Oct 27, 2014 4:38 AM by GaryBenzon

    Invoice line items: Repeating field vs. line item table

    GaryBenzon

      Title

      Invoice line items: Repeating field vs. line item table

      Post

      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.

      GB