i have programatically inserted value in id
it is also working
append command working properly
please you see my selectcmd in that command i have give inner join command
if i cancle the inner join command this CA working very nice (add edit delete working properly) but i need inner join bcoz releted recored want to display in form
if i delete a record inner join referance table whsudealer in that record has beed deleted and error also occured
so please see my selectecmd

now i have deleted relationship in sql server

but is not gone

so please where i am wrong