I have a wizard and in step 1 i have form for employee once i click next i am inserting employee and empid is generating by sequence. And Next click will open address form where i insert multiple addresses for the previously saved employee.
1. How to fetch the employee id for insert adresses . ?
create master detail form
your master contain Employee Basic information.
and detail table contain empid as a foreign key and address field in which you can add multiple address
for perticular empid.
use the returnign clause to capture the employee_id generated by the sequence.
check the following for an example
assign this returned value to an application item
when you reach the next page this application item will have the necessary employee id in it. you can then update the record with the new info
let me know if this answers your query in the current thread