developer 2000 master detail relationship
From: <ssharma24_at_my-deja.com>
Date: Wed, 19 Apr 2000 22:03:52 GMT
Message-ID: <8dlafu$ien$1_at_nnrp1.deja.com>
[Quoted] I have a form that has a master and detail block… [Quoted] Master block (tabular form) is based on a table that has a primary key which is coming from a “sequence” and a “before insert database trigger”.
Detail block (tabular form) is based on a table that has the primary key of the above block as its foreign key. When ever I add a record in the master block and save it, that’s when the primary key gets added to the record (right before the insertion to the database). But at this point the value doesn’t show in the actual field on the form. If I hit f7 and f8 then It shows up.
Date: Wed, 19 Apr 2000 22:03:52 GMT
Message-ID: <8dlafu$ien$1_at_nnrp1.deja.com>
[Quoted] I have a form that has a master and detail block… [Quoted] Master block (tabular form) is based on a table that has a primary key which is coming from a “sequence” and a “before insert database trigger”.
Detail block (tabular form) is based on a table that has the primary key of the above block as its foreign key. When ever I add a record in the master block and save it, that’s when the primary key gets added to the record (right before the insertion to the database). But at this point the value doesn’t show in the actual field on the form. If I hit f7 and f8 then It shows up.
The problem is that the detail block foreign key has “copy value from item property” filled with master_block.primary_key. So, the moment for which that field is empty, the value doesn’t get filled. Is there a way out of this problem. So that, users don’t have to hit f7 and f8 to start adding values to the detail block.
Thanks..
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Apr 20 2000 - 00:03:52 CEST