My database has 2 tables, the first holds just the most recent data collected used for a display. The second table isnearly identicle to the first but holds all transactions of the first table as historical data.
What I need is a trigger to detect when a line is added to the first table and have that data enterred into the second history table.
I can trigger on an insert since my app deletes the current record in the display table and then inserts the new data.
Can anyone help me clarify how to format a trigger event to handle this?