Hi, is it possible to do the following in the Interface Designer or in Forms (old/new)?
I want to create an "add new order" page/form, which will show the user all possible products taken from the Products table, and next to each item the user would be able to enter the desired quantity.
Would look something like this:
Product | Qt. |
product1 | <user input> |
product2 | <user input> |
... | ... |
after submitted the form a new order needs to be created with each row in the above table becoming a new record in "Order Line Items" table. I'm ok using scripts if that will allow it.
Is this possible?
Thanks.