Preventing to save a detail-less master record [message #143171] |
Wed, 19 October 2005 06:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dev73
Messages: 12 Registered: October 2005 Location: B
|
Junior Member |
|
|
Hi,
Using developer forms 6i,
I made a simple master detail form using wizard. Now
I dont want to save any master record without a detail record.
In other words, I want to make sure that every master record
must have atleast 1 detail record.
How can I do this.
Thanks
|
|
|
Re: Preventing to save a detail-less master record [message #143303 is a reply to message #143171] |
Wed, 19 October 2005 17:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I don't (currently) know of any forms setting that will do this for you (but I will have a look later today as I have some long running jobs to perform and may have some free time).
What does a get_block_property ('detail', current_record) return to you from an On-Commit trigger on the 'master' block when (1) there are no records in the 'detail' block, and (2) you have keyed data into the 'detail' block and then 'deleted' it using the 'Clear record' button, and (3) when you have finished one 'detail' record, moved 'down' to a second 'detail' record, and then returned to the first 'detail' record and 'deleted' it?
Experiment, and let us know your results.
David
|
|
|