Home » Developer & Programmer » Forms » Insert record in detail block but not in master block (Oracle forms 9i. windows)
Insert record in detail block but not in master block [message #400416] Tue, 28 April 2009 02:11 Go to next message
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
Re: Insert record in detail block but not in master block [message #400423 is a reply to message #400416] Tue, 28 April 2009 02:31 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do not INSERT customer information if it already exists - fetch it (enter_query, enter search criteria, execute_query).
Previous Topic: Populating the data in respective excel columns
Next Topic: Oracle Forms lov
Goto Forum:
  


Current Time: Fri Sep 20 10:23:33 CDT 2024