updating/inserting from one table to another

[Greg25]

Here I go again,

Is it possible when changing what we call the status of a project from one cost center to the next cost center, and to be able to place some of that data into another table?

The name of the table that is getting updated is order_entry field Last_cost_cener_code the one I need updated is job_workflow field Last_cost_center_code +date, time when entered and then when it changes to the next cost center to enter the date, time when it has left that cost center both tables have their own unique row_id number as the primary key

Like I said in other threads I have only been working with this stuff for a short time not knowing anything three months ago.

I hope someone can help

 

[foxdev]

It sounds like you want to put an update trigger on the table order_entry. This trigger could insert or update the values in another table. Basically, in the trigger you would check if the Last_cost_cener_code column was updated, and if so, use the values in the pseudo table inserted to perform an update (or insert, depending on what your needs are) in the other table. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[Greg25]

Thanks that what I thought
You mention the pseudo table I will have to look that up
It must be a temp table or some thing