Re: form query problem

Thenard,

When you create a Relation between the master and detail blocks in Developer, Forms automatically generates a number of triggers and program units. Of these, 'query_master_details' executes a query in the detail block whenever a record is fetched in the master block, so what you need to do is influence the detail block query at run-time. Create some non-base table items in your Master block which correspond to the columns in your detail block, and set Query Allowed = True (thus making them navigable in Enter-Query mode).
Then, in the Master block's Pre-Query trigger you can set the Detail block's Where clause, ie. Set_Block_Property(your_block, DEFAULT_WHERE, 'criteria');
Alternatively, you can set the detail-block columns directly in the Detail block's Pre-Query trigger.
Using a trigger in the master block has the advantage that you can validate the query criteria entered.

ªü´ö Thenardier <Thenardier_at_pk.POBoxes.com> wrote in article <36446f30.1070398_at_news.netvigator.com>...
>
> hi,
>
> there is a form which has 2 items on the top of it and a detail
> block at the bottom. in enter query mode, the user should be
> able to input search values, say, "%", in that 2 items *and* in
> some columns in the detail block. the 2 items and the details are
> in different blocks. i find that, enter query only allows users
> to input search values in *one* block only. if the items for
> queries come different, enter query seems have no use.
>
> am i right? how to handle it, then?
>
> thanx in advance.
> thenard
> -------
> pls remove pk. in reply, thanx.
> ¦^ÂЮɽЧâpk. K ±¼, ÁÂÁÂ.
>
Received on Mon Nov 09 1998 - 00:00:00 CST