Re: DATA BLOCK defined as a join??

From: Geoff White <whiteg_at_ccis.adisys.com.au>
Date: Fri, 27 Aug 1999 10:04:29 +0800
Message-ID: <37C5F22C.728E2DE3@ccis.adisys.com.au>

newbie22_at_my-deja.com wrote:

> HI all,
>
> I have been able to create a few data blocks,
> synced to individual tables, and join them
> together in a relationship.
>
> A view on the server would create the join
> automatically.
>
> In Forms 5.0, is it possible to create ONE
> data block, defined as a join between two or
> more tables, without a relationship?
>
> Thanks,
>
> Newbie
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Yes, you can.Set the Query Data Source Type of the block to 'FROM clause query' and type your select into Query Data Source Name. Have a look at the help under 'FROM clause' for details.

HTH
Geoff Received on Thu Aug 26 1999 - 21:04:29 CDT