Home/ Questions/Q 2792
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-10-30T21:37:09+00:00

Fill Interactive Grid from another table in Oracle Apex

  • 1
  • 1

Hi,

I have a Sale Invoice page and want to fill IG when user select order number from dropdown and a Dynamic action fill the records into IG from orderItem table. how to achieve this using java script.

Just like fill a Oracle Tabular Form from cursor.

Thanks

igoracle apex
Share
Leave an answer

Leave an answer

Browse

2 Answers

  1. You no need to do this using JavaScript, but you can do it using its default feature. Follow these steps:

    Create an interactive grid based on the OrderItem table and specify the where clause as following:

    order_number = :px_yourOrderList

    Add the item px_yourOrderList to items to submit.

    Then create a dynamic action on your OrderNumber drop-down list on the Change event to refresh the IG region.

    Now, whenever the user selects any order, the IG will refresh to show the data for the selected order number.

  2. Hi,

    Thanks for your reply. There is some other points how to add records to saleitem table when user submit and there are other columns in saleitem table which are update by user. we just need when create a new sale invoice pick the items list from order table and other value updated by user.

    Thanks