I have an
EvidenceTimeStamp table that is triggered with data when the case table has data inserted into it.
I created a trigger to fill the first four columns of data whenever a new case is inserted in the case table and it creates a timestamp on
Evidence_Initiated_Timestamp when this happens.
However, I need to create a closing timestamp when the process is complete. I wanted to do this by my Outbound Ship Table- everytime the Attribute (bit value)
Outbound_Item_Recevied is changed from false to true (or 0 to 1) I want it to initate a timestamp on the
Evidence_Returned_Timestamp column in my
EvidenceTimeStamp table that matches the corresponding
EvidenceTimeStamp table does not have a primary key or foreign key technically... the
CaseID is primary key in the
Case table and
EvidenceNum is an attribute in the
Evidence Table. This is a "trigger" table so it really doesn't have its own specific data, it's just filling data from other tables.
Any idea of how to do this?
Also, other quick question, how do I get bit values to show "True" or "False" instead of 1 or 0? Thank you!!