I have a form in which a customer need to fill the products he wants to order.
The relevant tables are:
Products - list of items and the prices
Orders- ID for each order (parent of Order_Detailes)
Order_Details - holds the list of chosen products for each order
I have a form in which a customer fills the products but in order to add a new item the main form “opens” a new one, like in here:
- these screenshots are from an example app “Order Capture”
It means that for each product the user needs to open a sub_form instead of doing it in the same form. this is quite annoying and not friendly for users/customers.
Is there an option to insert the list of items inside the main form with an option to add a new item and select the quantity? or something like “adding to a cart” option?
I have tried “Drop-down from valif_if” and “Dependent drop-down” but that’s not the solution.
Thanks a lot