How To Manipulate Multiple Tables From One Tabular Form In Oracle APEX?

889 views Asked by At

I want to update two tables at a same time in tabular form. But without tabular MRD and MRU process, how can I work with the selected checkbox item?

Also how can I calculate total unit price of a product in tabular form , when quantity of that product are updated?

enter image description here

Scenario: When I click on "Add Item" button on left side then the tabular order generated in right side.

Now I want to update the STOCK TABLE and ADD_PAYMENT TABLE of the selected item as well as total price according to changes quantity in right side tabular form.

My three table MENU_ITEM,ADD_PAYMENT and STOCK table create script are given below.

CREATE TABLE  "MENU_ITEM" 
       ("M_ID" NUMBER(10,0), 
        "ITEM_NAME" VARCHAR2(50) NOT NULL, 
        "PRICE" NUMBER(10,0), 
        "STOCK_STATUS" NUMBER(10,0), 
         CONSTRAINT "MENU_ITEM_PK" PRIMARY KEY ("M_ID")
      USING INDEX  ENABLE
       )
    /
CREATE TABLE  "ADD_PAYMENT" 
       ("ID" NUMBER,
        "ORDER_ID" NUMBER(5,0), 
        "M_ID" NUMBER(5,0) NOT NULL, 
        "PRICE" NUMBER(5,0) NOT NULL, 
        "QUANTITY" NUMBER(5,0) NOT NULL,  
        "TOTAL" NUMBER GENERATED ALWAYS AS ("PRICE"*"QUANTITY") VIRTUAL , 
         CONSTRAINT "ADD_PAYMENT_CON" PRIMARY KEY ("ID")
      USING INDEX  ENABLE
       )
    /
CREATE TABLE  "KITCHEN" 
       ("K_ID" NUMBER(10,0), 
        "M_ID" NUMBER(10,0) NOT NULL, 
        "QUANTITY" NUMBER(10,0), 
         CONSTRAINT "KITCHEN_PK" PRIMARY KEY ("K_ID")
      USING INDEX  ENABLE
       )
0

There are 0 answers