Re: Forms 4.5 How to query details in master_detail relation?

In article <53brbq$ocv_at_milo.vcn.bc.ca>, Juan Pon <jjpon_at_vcn.bc.ca> wrote:
>In a master_detail relation, if I query a master block, ALL its
>details are fetched. If I then go to the details block, I can narrow down
>the details by entering another query. But if I scroll down to the next
>master record, once again ALL its details are fetched. How can I fetch
>only those master records containing some specific detail criteria? For
>example,

I don't have any experience with master/detail blocks, but you might try setting the detail block's Default_Where clause before querying the master block. You can set the clause at design time, or at run time with set_block_property.

HTH
Steve Cosner Received on Tue Oct 08 1996 - 00:00:00 CEST