Hi:

 

I am creating an Inventory Application, which includes invoicing functionality as well. When a customer is invoiced, it will reduce the product stock amounts currently in the inventory by the amount listed on the invoice. etc...

 

However, I would like to know if it is possible, in my Invoice table/form, to be able to add multiple products to an invoice, similar to the "add another line" feature in the Invoices in Zoho Invoice, show in the image attached. As of now, each invoice can only accept one product, since i do not want to have fields/columns for Product1, Product2, Product3, Product4 etc since the form would be quite cluttered and long.

 

I am guessing i might also need another table to store the product details and use the invoice number to link the items in that table to the main invoice.

 

Any Thoughts?

Thanks