update table automatic using temp variable

Question

hello everyone i am confused how can i do not know pls help me:- i use three table. name is 1) ExpectedVisitorTable 2) GatePassTable now first I insert record in Expected Visitor c# Form and save record in ExpectedTable. then i get Expected Visitor's record show on GatePass Form. and then i save record in GatePass Table and then automatic update expected visitor table's fileld name is expectedentry 0(zero) (note- expectedentry default value is 0(zero) but i want to update to 1(one)) now how can i update automatic expectedentry field. which query i use to update???

Francis · Answer

now how can i update automatic expectedentry field. which query i use to update??? You need to consider to use triggers.You should create trigger on the GetPass table. CREATE TRIGGER reminder1 ON GetPass FOR INSERT AS UPDATE ExpectedVisitor set expectedentry ='A' Hope this helps!

Prem Anandh Natchatran · Answer

use triggers in your database and update the ExpectedVisitorTable field when record modified in GatePass. refer triggers.