Re: Multi table in one datablock

It cannot not be done. However, I have heard that some versions of Oracle allow one to create views (that are complex) with Inserts, Update, and Delete capablity. Version 7.1 of the Oracle database is not one of them. There are also some techniques which can be use which invlove non-base table fields, pre-insert, pre-update, and pre-delete triggers. Very tricky. I would not do it.

Gerben Braakman wrote:

> Hi,
>
> Can anyone explain how to solve the following :
>
> We want to create a form in which search criteria can be entered in a
> number of fields. There is only 2 tables in a master-detail relation;
> both master and detail fields must be accessible and enterable.
>
> The problem is that if a screen like this is generated, 2 datablocks are
>
> created; when entering search data in one of the master-fields, it is
> not possible anymore to put data in the detail fields.
>
> How to create a form like this?
>
> Thanks.
>
> Gerben
Received on Fri May 26 2000 - 00:00:00 CEST