CODEWITHSUNDEEP
oracle-databaseoracle-apex
Michiel Borkent
Michiel Borkent

Reputation: 34800

Oracle APEX form based on multiple tables

Can I create a form in APEX which creates/updates records in multiple tables? For example two tables with a one-to-one relationship.

Upvotes: 2

Views: 8145

Answers (2)

Tony Andrews
Tony Andrews

Reputation: 132570

A simple way would be to create a view that returns the joined tables and base the Apex form on that. You may need to add INSTEAD OF triggers to the view to be able to insert and update successfully.

Upvotes: 0

Erkan Haspulat
Erkan Haspulat

Reputation: 12552

If you are using Automated Row Fetch mechanism, you can use two different ARF for two tables. If you want to have more control, you can define your INSERT/UPDATE statements yourself usign Page Processes.

Upvotes: 3

Related Questions