Re: Multiple table query

1 control block with the query fields on canvas1 2 datablocks with customer=master, orders=detail, on canvas2 2 datablocks with orders=master, customer=detail on canvas 3

depending on what is entered in the query/control block, go to the appropriate master block.

think it'll work?

"Jan" <wilsonjanNOwiSPAM_at_bigfoot.com.invalid> wrote in message news:2d56739d.054f2b30_at_usw-ex0106-048.remarq.com...
> Hi,
>
> Tool: Forms 60
>
> I have two table one customer and the other orders.
>
> Does anyone know how to create a datablock that can query any column
> from either table and produce a result set from a join to both tables ?
>
> eg. I enter the customer name and the customer details are retrieve to
> gether with its orders.
>
> The above I can do by simply creating two datablocks with a
> relationship between them.
>
> But consider the following example:
>
> I enter the product code from the order table and all customer ordering
> that product are returned.
>
> I would like to create a form that could cater for both of these
> situations WITHOUT USING VIEWS.
>
> This is my first posting, so my apologies if it is in the wrong forum.
>
> Thanks in advance
>
> Jan.
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
 *
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Thu May 25 2000 - 00:00:00 CEST