Hi,
How to delete a record from DataGrid controls 
with fields from multiple tables through the SQL query.
For example,
 
Adodb1 has the following:
 
CommandType=dCmdText
ConnectionString=Provider=Microsoft.Jet.OLEDB.3.51;Persist Security 
Info=False;Data Source=C:\Program Files\Microsoft Visual 
Studio\VB98\Biblio.mdb
CursorLocation=adUserClient
CursorType=adOpenDynamic
RecordSource=SELECT Titles.Title, Titles.[Year Published], Titles.ISBN, 
Publishers.Name FROM Titles INNER JOIN Publishers ON 
Titles.PubID=Publishers.PubID ORDER BY Titles.Title
 
 
I don't have trouble to delete a particular record if the recordsource 
is 
from one table (i.e., Form Access).
If it is from multiple tables, then I have run-time error saying that:
    Insufficient Key Column information for updating and refreshing.
 

How do  I solve this problem?
 

Cash Chew