Automatically populate primary key from table 1 table into table 2
650629Jul 21 2008 — edited Jul 21 2008I have an application I am developing in Apex, I posted last week on the same app but have since been instructed that it has to be developed a particular way, ie different from how I did it last week.
Ok, I have a form and report on on a table TRK_CALLS my data includes
ID (Primary Key)
User_
Assigned_to
Problem
Solution
Status
I also have a form on a table TRK_CALLS_TIME my data includes
ID (Primary Key)
Call_ID
Date_
TIme
I can got to the report click create and and it goes to the form I then fill in the User_, Assigned_to, Problem, Solution, Status. ID is hidden. I can then hit create and it takes me to the TRK_CALLS_TIME form and I fill in Date and TIme. I hit create and It takes me back to start.
I look at my tables and entries are created in both table including the primary keys.
What I need to do is have the application automatically insert the same ID(primary key) number from TRK_CALLS into the CALL_ID column of TRK_CALLS_TIME. How can I do this using the application process I explained above?
I am new to apex and not great at PL/SQL so please take me step by step.
Thanks for everyone's time,
Kirk