Re: Prevent master record without detail records

[Quoted] Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be> wrote in message
news:Ik5d4.160$SC2.2059_at_afrodite.telenet-ops.be...
> Did I read right?
> This is impossible in a relational model: The master must
exist before the
> detail can be made.
> Can you explain your problem a little bit more in detail?

Hello,

For instance, suppose you have a master block with customer orders
and a detail block with items for each order. I want to warn the user
if he/she tries to commit an order with no items.

Dinis

> > I've a form with two blocks: a master and a detail.
> > I'd like to prevent the creation of master records
> > for which no detail records were defined.
> > What's the best way to achieve this?
> >
> > We're using:
> > Forms [32 Bit] Version 6.0.5.31.0 (Production)
> > Oracle8 Enterprise Edition Release 8.0.4.0.0 -
Production
> >
> >
> > Thanks for your time,
> >
> > Dinis
> >
Received on Thu Jan 06 2000 - 20:09:07 CET