Re: master detail query
From: maher <totonut_at_mailcity.com>
Date: 22 Aug 2002 02:10:01 -0700
Message-ID: <40aad53e.0208220110.3435a5b4_at_posting.google.com>
Date: 22 Aug 2002 02:10:01 -0700
Message-ID: <40aad53e.0208220110.3435a5b4_at_posting.google.com>
hi joost
thanks ,
I found the solution for that .
I copied
"
declare
rel_id Relation;
BEGIN
IF ( (:REP_TAB.COMPANY_CODE is not null) or (:REP_TAB.AREA_CODE is not
null) or (:REP_TAB.CLASS_CODE is not null) or (:REP_TAB.TYPE_CODE is
not null) or (:REP_TAB.REP_NUM is not null) ) THEN
rel_id := Find_Relation('REP_TAB.REP_TAB_BORROW');
Query_Master_Details(rel_id, 'BORROW');
END IF;
"
form the on_polpulate_detail trigger
Thanks Again
Maher
and it worked Received on Thu Aug 22 2002 - 11:10:01 CEST