Which Form to use to insert into multiple tables?
Hi,
What's the best way to create a Data Entry Form which inserts into multiple tables?
I'm a newbie to APEX, without any training yet. APEX looks like a viable solution for Forms and Reports, which is exactly what my current project needs. However, I hit several major bottlenecks as follows:
I understand that a tabular form ONLY can insert/update ONE table. So I manually created a form by following the APEX User Guide as follows:
1) creating a HTML region (to serve as a container for my page items), and
2) created items to display in the region, and
3) created a "Insert" button at the bottom of the Form to insert into a view (which comprises of multiple tables)
However, upon pressing the "Insert" button, I got the following error msg:
Error No updateable report found. Multi row updated and delete operations can only be performed on tabular forms of type 'Updateable Report'.
Q1) (On Page #7) What does it mean? How to correct it? Or should I use other Form?
Q2) On Page #2 (Home page): I want to have 5 Forms showing up on the Home page for the user to select which Form to process, once the user logins. And each Form has Insert, Update, Delete Forms for user to choose from. So it's something like the following:
Login -> Home -> Form1
InsertForm UpdateForm DeleteForm
-> Form2
InsertForm UpdateForm DeleteForm
-> Form3
InsertForm UpdateForm DeleteForm
-> Form4
InsertForm UpdateForm DeleteForm
-> Form5
InsertForm UpdateForm DeleteForm
I use 5 regions to implement it. Since they are Navigation Regions, so it's under the Shared Component. Thus Form1 InsertForm, UpdateForm, DeleteForm show up in every single regions, which is NOT what I meant. How can I use 'condition' to make them show up selectively? Or what's alternative to implment such?
Lastly, if someone could kindly take a look of my application, I've uploaded it to apex.oracle.com, together with a table called "FUNDINGAGENCYLUTB" (for the cascading select). See info below:
Workspace: Test_0712
Application: njfmrn0712_39355
Page#: 7
User: demo
Pswd:demoPswd
Much appreciated,
Helen