Creating a trigger

A

Andre

I was wondering on how to create a trigger so that my primary key updates the
relative table or the foreign table.

Here is what I have in my tables. I have set the primary to YES for Identity
Seed.
What else do I need to do?

Primary Table 1 (Employee) Columns
*Call_ID (Primary Key)
First_Name
Last_Name
Email
Date_Time
Phone_Local

Foreign Table 2 (Call_Tracking) Columns
Call_ID (Foreign Key)
Department
Dept_Assigned
Date_Assigned
Date_Opened
Date_Closed
Opened_By
Closed_By
Tech_ID
Description
Resolution

Am I missing Something? If some one could tell me how to do the triger for
this I would be so very happy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble Importing XML File using XSL 0
Run Query generates SQL without a JOIN 2
Creating a key consisting of two columns 1
building a complicated (to me) string 9
creating foreign key 2
building a string in a public function 1
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database? 0
In SQL database, do I need to fill in rows under a foreign key attribute? 1

Top