Home » Developer & Programmer » Forms » Preventing to save a detail-less master record
Preventing to save a detail-less master record [message #143171] Wed, 19 October 2005 06:40 Go to next message
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
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
Previous Topic: menu problem
Next Topic: message Field must be enter - when exit form
Goto Forum:
  


Current Time: Fri Sep 20 03:45:15 CDT 2024