I have datagrid
and data is shown from table A Anb B
table A contains client id and B his cheque details
cleint id is a foriegn key in table B.
in datagrid i want to show the cheque details,
and i want edit and delete all things from teh datagrid itself.
/// SQL Stmt
rs1.CursorLocation = adUseClient
rs1.Open "SELECT A.ContractID, B.ChequeNo, B.Bankname, B.chqamt, B.status, B.chkdate FROM Contract AS A INNER JOIN ChequeDetails AS B ON A.ContractID = B.ContractID", conn1, adOpenDynamic, adLockOptimistic
Set dgdCheque.DataSource = rs1
Can u please help me in this