help help help urgent

Hi
We are using oracle 8 and developer 5.0 Background:
Sales invoice entry form and sales order entry form both are running on different win-95 machines. Each form is using "POST" built in procedure of oracle.
When a sales order number is queried, changed and posted on one computer(but not yet committed). The another user is working on sales invoice entry and trying to get items being ordered in different sales order other than the one posted by that user.
Problem:
The second user(one who is trying to prepare invoice) is getting message 'working.....' while getting sales order details. When the sales order details are committed, the invoice user get access to sales order details. Why?

Invoice entry form contains sales_order_item block use only to query the items from sales_order_item table.

sales_invoice table (sales_order_code) is referenceing sales_order_item table.
Pls contact
micind_at_bom3.vsnl.net.in Received on Sat Aug 14 1999 - 08:00:29 CDT