Delete Query Help

[MadMax7]

Hope someone can help

I am trying to run the following delete query

SELECT tblAlternativeNetworkCallDetail.*, CDate(Left([StartDateTime],10)) AS Expr1
FROM tblAlternativeNetworkCallDetail INNER JOIN tblMidTermAnsPoints ON tblAlternativeNetworkCallDetail.TAD = tblMidTermAnsPoints.TAD
WHERE (((CDate(Left([StartDateTime],10)))=[forms]![FrmPreviewReport]![txtStartDate]));

but when i try and run the query i am getting a error sayinmg that i can not "delete from specified table"

i have chencked the help file and this mentions security issues and read only issues, none of these are a problem

 

[Remou]

It seems most likely that neither of your tables has a unique index.

 

[MadMax7]

sorry do you mean i need to add a primary key into one iof the tables

 

[Remou]

Yes, I do. Deletes do not work with joined tables where neither of them has a key field.