Try this:

Create Trigger trgAddSupportRecords For Jobs
After Insert
Position 0
As
Begin
Execute Procedure spAddSupportRecords(New.JobNo);
End !!

This is what Thomas suggested.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)