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???