we have an inventory app that allows users to place internal orders for supplies that we then ship to clients. the ‘order supplies’ view uses the form view and has 2 drop down lists, clients and products among other fields, completing the form adds a single row that acts as an order to the sales table.
due to this setup each order can only contain 1 type of product, the user can modify the quantity, but if a client needs 2 or more kinds of products ordered at the same time, they need to be done as separate submissions on the form.
is there a way to build this where the form can select a single client and multiple products without having to add products into more columns and instead create more rows upon form submission?
LinkedIn
Twitter
