Hi,
I have a custom form developed using forms6i.
It has 2 datablocks (both are view based) + 1 query find non db block. They are master detail data blocks developed using wizard and both are tabular blocks.
This custom form is used in Oracle EBS 11i version.
Now when user enter a new row in master block, I need to make sure he enter detail block as well and system should not allow the user to move the cursor using mouse or tab to any other place (e.g. other rows in master block or query find block).
I am using On-Insert and On-Update trigger for storing and updating rows in base tables of views on which datablocks are based.
How do I achieve that, I already tried below things.
I made detail block's some columns Required as Yes in property pallete .-- In this user can bypass this by only entering master record and then moving to some other existing row in master record and then pressing ctrl+S
I tried using set_item_property to Required as Property_True, but it can be bypassed again , by going to some other existing row in master block and then pressing ctrl+S
Thanks in Advance
VK