Forum Stats

  • 3,780,464 Users
  • 2,254,398 Discussions
  • 7,879,339 Comments

Discussions

Create a form on join tables/view

2778983
2778983 Member Posts: 7
edited Nov 12, 2014 6:26AM in APEX Discussions

Hi, I think I posted this in the wrong place before.

Anyway I have this issue, I need to create a form that inserts on to more than one table, i have created this view:

CREATE OR REPLACE VIEW AS

  SELECT o.order_id, i.order_item_id, c.customer_id, c.customer_fullname, p.product_id, p.product_name, NVL(i.quantity, 1) as quantity, p.product_price, (NVL(i.quantity, 1)*i.unit_price) as "Sub Total", o.total

FROM customers c

JOIN orders o

ON o.customer_id = c.customer_id

JOIN ORDER_ITEMS i

ON o.order_id = i.order_id

JOIN products p

ON i.product_id = p.product_id;

I have used automatic row fetching and automatic row processing

The page has only customer fullname, product name and quantity visible, i have hidden the rest. When i run the page, enter data (which are a list of LOVs) and click create I get this error: ORA-01779: cannot modify a column which maps to a non key-preserved table.

Could someone please assist me with this thank you

Tagged:

Answers

This discussion has been closed.