Insert record in detail block but not in master block [message #400416] |
Tue, 28 April 2009 02:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
honey_28112007
Messages: 10 Registered: March 2009
|
Junior Member |
|
|
I have a master-detail relationship in two blocks. Master block is customer and detail block is order block.Customer block is based on customer table and order block is based on order table . both are joined by Customer id.
My problem is .. when i want to enter a new order entry first i enter the customer name.. if the customer name is already stored in database i retrieve it using lov . and i navigate to order block where i enter the order detail. but here it gives me the error that the record is already entered as the existing customer's id and name is already in the table
When i want to place order for any new customer then it work fine but for an existing customer it doesnt.
What idea should i use to solve this problem
|
|
|
|