putting a select statement in a trigger

[dmcmillan]

The insert works ok, but it isn't connecting to the other two tables. I think that's my problem. I'm missing something I need to do to select from the other tables.
And you are right, it won't run very often.
Thanks!