This content has been marked as final. Show 6 replies
First of all, Primary key is defined on Table Lavel.
On Forms - Did you created the Relations ship, if not create relation ship first.
Secondly, when you ask question, please ask us generic using scott schema.
How you u have scott schema in 11g -> http://appslearner.blogspot.com/2012/12/how-to-have-favourite-today-i-installed.html#more
Dear Mr. O.Developer, Many thanks for your reply.
Yes, I've created relationship. Relationship exist in Master_Block and below is the detail
Relationship Name = MGTC_EDM_MGT_EDD
Relation Type = Join
Detail Data Block = MGTC_EDD
Join Condition = MGTC_EDD.EDM_ID = MGTC_EDM.EDM_ID
Delete Record Behavior = Non Isolated
Prevent Masterless Operations = No
Deferred = No
Automatic Query = No
So, I've solved my problem by applying a "KEY_NEXT_ITEM" trigger on master-block field BILLING_DATE. Detail is as under:-
IF :BILL_DATE IS NOT NULL THEN
MESSAGE ('PLEASE PROVIDE BILL DATE');
SELECT EDM_ID INTO :MGTC_EDD.EDM_ID FROM MGTC_EDM WHERE MGTC_EDM.EDM_ID = :MGTC_EDM.EDM_ID;