view generated by forms 3.0

I post this on behalf of Wytze Schilstra, please reply to the From: address.

---
I work with ORACLE V 6, Forms v 3.0.16 on a VAX. I have the following 
question: 

Considering the parent table orders with the attributes (orderno,
orderdate, ... etc) and the child table items (orderno (FK), articleno,
custno). Suppose I want to create a block where I want to show a list of 
orders.orderdate items.articleno and items.custno with conditions for the
articleno or whatever only for query purposes.

The standerd way to do this is by making a block with items as base_table
and to get the corresponding orderdate through a post_change trigger.
However, I have the impression that there might be an other way to do this.
Forms gives no error message when I create a block with base_table:


"orders,items". In the default where clause I specify:


"where orders.orderno = items.orderno and ....". The fields For this block


are: orderdate, articleno and custno and purpeously not orderno!!! 

Even generation of this Form gives no problems. But when I run this form I
get Error message: "select orderdate, articleno, custno, rowid from ...".
The error is caused by the fact that the column rowid is ambiguously defined.

Does anyone know a solution for this problem? For instance a view, which
by definition has no rowid (>1 table) can be used without anay problem as
basetable in forms.