the sql will not delete from the tables if more then 2 rows have to be deleted... can sombody please have a look and guide me in the right direction whow can i make it to delete all entries from the secondary table no matter 1 or 20 entries.
y = Request.QueryString("y")
set DoDelete = Server.CreateObject("ADODB.Command")
DoDelete.ActiveConnection = "kratistos"
DoDelete.CommandText = "DELETE Quotes.*, QuoteDetails.* FROM Quotes LEFT JOIN QuoteDetails ON Quotes.QuoteID = QuoteDetails.QuoteDID WHERE (((Quotes.QuoteID)="& y &"))"
DoDelete.CommandType = 1
DoDelete.CommandTimeout = 0
DoDelete.Prepared = true