trigger to cascade new entry to second table

[philrm]

I need cascade entry of a number field (long int) from one table to another. The first table holds the primary key which is the number that needs to cascade to a second table. The second table is also using the number a primary key (not sure this is ok). Should I use a trigger on insert to do this or should the trigger execute a stored procedure?
What would be the correct syntax for the sql statment to make this type of thing work?
Can anybody point me to some good info on triggers and how and when to use them.

 

[foxdev]

create trigger InsTrigger
on MyTable
For Insert as
insert into MyTable2
select MyNumField from inserted

Robert Bradley

http://www.foxdev.com/

 

[crystalized]

I actually found the books on line provided enough examples for me to figure out how to write the one simple trigger I needed to create.

I would give the books on line a try.
Crystal
crystalized_s@yahoo.com

--------------------------------------------------

Experience is one thing you can't get for nothing.

-Oscar Wilde