Re: Forms4.5 Master/Detail

You might play around with the following:

Create a detail_count non database column in the master block. Master block post-query trigger does a select count (rowid) from detail_table. Master pre-insert/update could test detail block status for "CHANGE".

post-record detail block triggers could update the :master.detail_count key-delete detail trigger updates the :master.detail_count ;

srijay_at_my-dejanews.com wrote:
: Hi,

: I have two blocks in a form. How can I ensure that there is at least one
: detail record exists for every master record. The user prefers to enter all
: the master records first, then go to the detail block and enter detail recs
: for each master rec. I know in this case I have to do my validation at
: key-commit trigger. But how can I read each master rec and check to see
: whether there are detail recs for that master.

: Any help would be appreciated.

: Thanks,
: Sri.

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.