Re: Master detail relationship

<nordhorn_at_my-deja.com> wrote in message news:8ggd4m$3q1$1_at_nnrp1.deja.com...
> Hi
>
> Ok here's my problem
>
> I have a master block CUSTOMER and a detail block ORDER. One customer
> can buy many products so it's one to many relation.
>
> CUSTOMER
>
> customer_id customer_name customer_home
>
>
> ORDER
>
> product_id customer_id order_date
>
> When i view the next_record/preview_record in the CUSTOMER block i want
> the ORDER block to update it's record accordingly. I also want to view
> the next_record/preview_record in the ORDER block.
>
> How can I do it.

1. Make sure there's a relation set up between the blocks.
2. In the property palette for the detail block, there's a "Deferred" property. Set that to NO or FALSE (I forget what it says).

Deferred = 'TRUE' (Yes) means that it won't query that block until you navigate there. That makes sense if the block is hidden on another canvas and window that you access via somthing like a button or something. If your block is always visible, then you want deferred = 'FALSE' so it "keeps up" with your master block real-time.

Also know that if you ever do validation between blocks (like if the master block has a field that's one value and based on that you do something to the detail block), make DEFERRED = 'FALSE' even if the detail block isn't visible. Otherwise you will have mismatched master-detail blocks when you perform your validation.

-Matt Received on Thu May 25 2000 - 00:00:00 CEST