Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Blocks and multiple tables
Create a non-database field in the block, and in the block's post-query
trigger populate it with a select <field> into :non-db-field from
<secondary_table>.
That field is then not updateable, by the way.
hth,
y
KRM wrote:
> Hello.
>
> I would like to be able to have a block display 10 records at a time.
> This is quite easy for a block that is getting data from only one
> table. However, I need to also include a field from another table. The
> data for these two tables are related in such a way that there is a one-
> to-one relationship. How can I set up my form so that I have fields
> from multiple tables in the same block?
>
> Thanks in advance!
> Kristen
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 03 1999 - 13:47:14 CST