Re: Forms4.5:Problem in Querying,please help

I would suggest that you have only one block.

The main part of the block is what you might like to expect -- multi record block.
Place it low in the block area.

Then add non-database fields to the block. The significant thing is that the non-database
fields are display once. I believe you set the # of records to 0 (zero).

During prequery trigger, move the values of the nondatabase fields into the corresponding database
fields. Remember to not transfer null fields -- although I do not believe this is required.

Mike Krolewski

fatima_haider_at_hotmail.com wrote:

> I'm creating an application in Forms4.5 in which i've created two blocks on
> the same canvas and both the blocks are from the same base table.In the first
> block, the user can enter query and in the second block i want to execute the
> query or i want to show the results of the query in the second block. The
> layout of the first block is form and the layout of the second block is
> tabular so that i can show more than one record. In the first block it's
> like, Search on City ----- and in the next block i want to display the result
> of this query. Can anyone tell me how to do this? Thanks.
>
> Sonia
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Wed Aug 26 1998 - 08:22:36 CEST