Your opinion about storing invoice line items as a list rather than records
What’s your opinion about
Line items of an invoice
store them as a complete list in the invoice header, store a list with each invoice
or store them as small records, each line item is a record
only advantage I can see for line item records is that you can search up what invoices a certain product appeared on real fast, but that’s not that common of a search request
seems to me you can safely store the invoice line items in one list in the invoice header
das goravani
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com