Tailoring a Trigger to a Certain Field

[kpcollier]

I have two tables, Est_Table and Job_Table.

Est_Table is filled with a ton of "bids" - Jobs that we are trying to secure. The fields in Est_Table consist of a BidID, Project_Name, Contractor_Name, and a Yes/No for Bid_To_Job (If a bid turns into a job, you check it).

I am trying to set up a trigger in the Est_Table. I need to tailor the trigger to only work when Bid_To_Job is updated. My goal is that when an entry in the Est_Table is updated to a Job, the entry (BidID, Project_Name, etc.) is automatically copied to the Job_Table.

I have it set up so everything copies over to the Job_Table if ANY field is updated in the Est_Table. Also, I am unsure why I can't select the Bid_To_Job field (is it because its a Yes/No data type?).

 

[JolliBeng]

Hello kpcollier,

Your Bid_To_Job field can be selected even if it is a Yes/No.

I tried it on my end, and it worked. I think, your Job_Table_Example does not have a Bid_To_Job field, that's why you cannot select it.

You can refer to this screenshot for the triggered actions:

These are the tables that I used:

.

Hope this helps.

 

-JolliBeng

[kpcollier]

@JolliBeng Thank you! That is almost what I need. With the trigger you supplied, an entry from the Est_Table will be copied over if ANY field is updated in the entry. I am trying to make it so only the update of Bid_To_Job copies the entry over. I will be trying to figure this out. Thank you for your help and getting me started!

[kpcollier]

While working with this trigger trying to figure out my problem, I thought maybe I could just create a new trigger. The idea of the trigger is that if any unnecessary entry is entered into the Job_Table, it would just be deleted from that table. But for some reason it isn't working.

 

 

[kpcollier]

Thought I figured it out. LOL. Oh well. I entered that trigger I previously posted into the end of the Est_Table trigger, that initially copies over the entries. So, now, it SHOULD work as anything updated gets sent to Job_Table, but anything that doesn't have Bid_To_Job as true is deleted. But, nothing is copying over anymore. On to the drawing board again.

[JolliBeng]

Hello kpcollier,

If you want to copy all the updated data from EST_Table to Job_Table and delete the data that has a checked Bid_To-Job, you may use this:

But if you only want to pass the values of the updated data from EST_Table to Job_Table without changing the status the Bid_To_Job on the Job_Table, you just need to remove it on your insert into statement like this: 

 

-JolliBeng