Very Computer

1. I have a table called control.  It has 10 records in it.
2. I also have a table called RevDtl.
3. For each record in control, I would like to make a record in RevDtl,
copying into it two fields of info from control.
4. I would also like to place into each newly added RevDbl record a
field from RevHdr.
5. I would like to do this after a new record has been added to RevHdr.

Thank you for your time.

Nina Paules

The trigger could look something like this:

create trigger t1 on RevHdr for insert as
insert into RevDtl
(c1,c2,r1) -- the fields we are filling with data
select c.c1,c.c2,i.r1
from control c, inserted i

/SG