Hi,
I have created a master detail form on reports. Initial report screen is about 'master table'. If I click 'Create' button, I get form to enter new record (only for Master table). If I click on 'Modify' button, I get both master & detail sections for edit (master-detail form).
My requirement is, if I click on 'Create' button on the initial form, I should get screen form which is similar to the one which we get when 'Edit' button is clicked. I mean to say, when I click on 'Create' button, I should see both master and detail sections. Also the 'Apply changes' and 'navigation' buttons to be visible. How to achieve this? The reason is, if user wants to create new record, he first has to create master record and save it. Again for the same record he has to click on Edit and enter rest of the detail records. They feel this as little lengthy process. When they initiate new record creation, in one shot, they should be able to enter both master data as well as detail data.
What I understood so far is, to achieve above functionality, I need to remove the 'Condition' defined for 'detail' report and also the condition defiled for 'Apply changes' button. By this, they will be visible all the time. However, this is not enough, especially when I don't use any sequence to populate primary key. After completely entering both master data as well as detail data (manually entering primary key) and saving it will gives error (obvious). This is because for saving detail records master record has not yet created. Is there any other template available to achieve this? Or there is a way to handle this?
I have created a sample in apex oracle -
workspace: test_ws_anand
user: anandgp
password: cable123
Select "Lab Test Entry" from menu when run. Or, page 11 and 12.
Thanks & Regards,
-Anand