Re: Master Detail not working properly.

From: Al Brana <albrana_at_ij.net>
Date: Wed, 13 Jan 1999 10:59:39 -0800
Message-ID: <ylAO$9wP#GA.188_at_rejz.ij.net>


Anton Wootliff wrote in message ...
>I am using Forms 5.0 and I create a Master Block and a Detail
>Block (the Master block is tabular). I enter a master record and
>then a detail record directly after... committing after both. If I change
>to another master record and then back to the master record I
>just entered the detail record is nowhere to be seen. I have to
>enter a query and execute a query to see the detail record. Why
>is this? Is there a way around it?
>
>Anton Wootliff
>Director of Systems Programming
>Cerberus Technologies Inc.
>wootliff_at_cyberealm.com
>
>

I would check the 'Copy Value from item' property in the detail block. Make sure it references the item from the master block. If that looks OK, go to the master block relation and copy (highlight and Cntl/C) the join condition. Drop the relation and re-create it with the join condition in your buffer (paste - Cntl/V). Careful, when you drop the relation you will lose the ON-POPULATE-DETAILS and ON-CHECK-DELETE-MASTER block level triggers in your master block. If you didn't add any code to these triggers you should be OK. This usually works for me. Hope it helps. Received on Wed Jan 13 1999 - 19:59:39 CET

Original text of this message