We are developing a Sales Order to Delivery process. We have created a master detail form to enter Orders received from customers. An order can have one or multiple items in it. The order number & order date along-with customer name is stored in the Master table and Item details (item, qty, Rate & amount) are stored in the Detail table. Let's assume we receive an order with 2 items / SKU's in a single order which is entered as 2 rows in the Sales Order form. At the time of Delivery the user may deliver either one of both items at the same time. Assuming that both items are to be delivered the user selects the Sales order Number from the drop down list. Based on the selected order number items from the selected sales order have to be filled into the Interactive grid (Detail table of Delivery Note).
I remember using a fillgrid option to fill the Delivery Note detail table in another low code application / tool with Oracle as the DB. We had a pop-up showing list of items from the selected Sales order (in the delivery note form) wherein the user could select an item / items that are going to be delivered.
My query is, whether such an option is available in oracle apex which we are not aware of to achieve this result
we are using Apex 20.2
Any help would be highly appreciated