I am making a Master Detail forms. The objective of this entry screen to capture questioners from the customers. We have 100 difference questions that customer support to answer.
I want to make a Master Detail in such a way that when the users has entered his basic information in the Master Form all the question should reflect in the detail form (get it from Question Master Table) and he just only click /tick the approporaite answer.
I have a master table to for all the questions.
Table Structure—
Master:
record_id number primary key,
record_date date,
user_ id number );
Detail
record_id number references master,
question_id number reference question_mst,
option_id number);
I am new to Oracle APEX though I have morethan 17 year of experience in Oracle Forms/Discoverer and EBS suites. Now trying to explore APEX.