I have started to create a simple Inventory application for a frozen foods company in Zoho Creator. What I need is to tie in invoicing functionality. I have created an "Invoice" table, where when a product is added to an invoice, it automatically subtracts the amount on that invoice from the inventory for that particular product when the invoice is successfully saved/created. Now the problem is that I need to be able to add multiple products to each invoice, so I need something like an "Add Product" link which the user would click on for each new product (with product details like price, quantity etc) which needs to be included on that invoice. I am not sure what the best approach is to do this. Anyway, I need someone to help me include this functionality in my application.
Writer is a powerful online word processor, designed for collaborative work.