hi
i have a simple relationship which is shown in the link below
http://www.flickr.co...N06/6948010043/
after doing much research i cannot find a proper way of deleting rows which are linked in all 3 tables.
could someone guide me on the best way of doing this.
This is the code i am using currently :
strsql = "delete * from cg_security_user_right where user_id=@field1 & right_id=@field2 "
Dim objcmd As New System.Data.OleDb.OleDbCommand(strsql, acsconn) ' the oledbcommand
With objcmd
.Parameters.AddWithValue("@field1", TextBox1.Text)
.Parameters.AddWithValue("@field2", TextBox2.Text)
End With
Dim result As Integer = 0
result = objcmd.ExecuteNonQuery()
objcmd.Dispose()
MsgBox(result & " Row Deleted")
End Sub