| Master Detail problem [message #83143] |
Mon, 11 August 2003 08:50  |
Saravanan S
Messages: 1
Registered: August 2003
|
Junior Member |
|
|
Hi,
Need to validate master Data with Detail Data. Eg master Qty = Sum of total Detail Qty. This should be validated before saving and Also need to maintain relation between two Data Blocks.
The Problem is that when we enter the Master Data and the details for First record and move to second record, Form Builder will prompt to save/ Clear/ post the Data. Also user may enter master Data for two records and then he may enter the details. In All scenarios our requirement is to commit the Data only if user does explicitly (subject to Above validation) and Post could not be done because of locking problem. We tried with record groups (Inserting the record temporarly) But its giving performance problem... when we inserted 70 records....
Can any one suggest the Best way of doing without Posting Data... Also there should be no performance issue....... ie.. need to insert data for more than one master record in master Detail Blocks
1. without committing Data
2. Without posting Data
3. Without using Record groups or any others methods leading to Performance issue
Reg
Saravanan S
|
|
|
|
| Re: Master Detail problem [message #83147 is a reply to message #83143] |
Tue, 12 August 2003 08:00  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
the validation (relation between 2 blocks) is build in the form. you can use the build-ins get_relation_property and set relation_property
to get rid of the check on master datail integrity
(see forms help F1 about relations).
just set the right property of a relation before inserting records.
check with a procedure all master and detail Qty within a procedure you will build (kinda menual check on integrity).
when data integrity is ok, then set the commen relation properties to maintain automatic data integrity check by oracle and then commit the form.
its just the use of relations.. read about it..
when the users get used to fill in one master then the detail data will save lots programmingcode for you!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
