Update in Join Query

[Drunkenneo]

I am strucked to a simple join query please help

Here I want to update the Flag of tblDataentry if any one of the orig or dest is -1 else 0. Please Help

 

[pr2-eugin]

I am strucked to a simple join query please help

Here I want to update the Flag of tblDataentry if any one of the orig or dest is -1 else 0. Please Help

I think you are missing a whole lot of detail ! Explain again?

 

[Drunkenneo]

I think you are missing a whole lot of detail ! Explain again?

Here i have added an image which will be ok for explanation

 

[pr2-eugin]

Sometimes, your Query might not be UPDATABLE, (http://allenbrowne.com/ser-61.html)

If that is not the case in your situation, then you need to show the Query you have tried and explain why it is not working..

 

[CazB]

Why have you linked the CodID to both the origin and the dest?

With that join in place, it will only match records where BOTH the origin and dest match the CodID... which would mean the origin and dest would have to be the same?

... also, which Flag is it you're wishing to update to True?

 

[Drunkenneo]

Currently i am using code
f is tbldataentry.origin
g is tbldataentry.dest
p = DLookup("flag", "tblCodes", "Cod_ID = " & f)
q = DLookup("flag", "tblCodes", "Cod_ID = " & g)

If (f = g) Then
MsgBox ("Origin and Destination cannot be same, Please Check")
Exit Sub
End If

If (p = -1 Or q = -1) Then
r = 1
Else
r = 0
End If

and updating value of r in flag of tbldataentry

Does it answers to your question?