Re: Query multiple tables in Forms 4.0 block?
Date: 1995/06/20
Message-ID: <jalford.217.0031E246_at_immcms1.redstone.army.mil>#1/1
In article <gbrown-2006951226370001_at_browng.partech.com> gbrown_at_partech.com (George Brown) writes:
>From: gbrown_at_partech.com (George Brown)
>Subject: Query multiple tables in Forms 4.0 block?
>Date: 20 Jun 1995 16:27:36 GMT
>Can you query, and in turn display multiple tables in a Forms 4.0 block?
>I have an ID that I want to "map" to a name which is contained in another
>table. I get an Oracle can't execute query error. Any ideas?
>--
>George Brown Voice: 315-738-0600x250
>8383 Seneca Turnpike FAX: 315-738-8304
>New Hartford, NY 13413-4991 e-mail: george_at_partech.com
Sorry, only one table per block !! Sounds like you need two blocks on the same canvas, so you can see them both at the same time. use a post-query trigger on the first block to fire an execute-query trigger on the second block ....
- huckleberry