I have done delete queries before but this one is not working. Ill just paste the script and see if you guys can point out the mistake, btw I did it in design view but seeing as though you all use script more. What it is, is all my 4 tables. I need to have the records with 'None' for Customers.M, 'None' for Customers.GM and 'No' for Customers.Lessons deleted. The 'None' is chosen from a Look-up field which has 2 columns and the 'No' is chosen from a Look-up field which has 1 column. Im not sure if you need to have Cascade records etc in the relationships on because I dont want to use enforce referential intergrity. Please help me 
Its a bit big
(I split it into the 3 main parts to make it easier to read)
DELETE [Current Game].*, Customers.*, Golfers.*, Teachers.*, Customers.M, Customers.GM, Customers.Lessons, [Current Game].CID, [Current Game].[Date of game], [Current Game].[1st], [Current Game].[2nd], [Current Game].[3rd], [Current Game].[4th], [Current Game].[5th], [Current Game].[6th], [Current Game].[7th], [Current Game].[8th], [Current Game].[9th], [Current Game].[10th], [Current Game].[11th], [Current Game].[12th], [Current Game].[13th], [Current Game].[14th], [Current Game].[15th], [Current Game].[16th], [Current Game].[17th], [Current Game].[18th], [Current Game].Total, Customers.PID, Customers.Surname, Customers.[First Name], Customers.Title, Customers.DOB, Customers.Sex, Customers.GID, Customers.DSUFM, Customers.EDFM, Customers.DSUFGM, Customers.EDFGM, Customers.TID, Customers.[Phone #], Customers.Email, Customers.Photo, Golfers.GID, Golfers.CID, Golfers.Rank, Golfers.TAO8, Golfers.TW08, Golfers.TS09, Golfers.TSm09, Golfers.TA09, Golfers.TW09, Teachers.TID, Teachers.Title, Teachers.Surname, Teachers.[First Name], Teachers.[Phone #]
FROM Teachers INNER JOIN (([Current Game] INNER JOIN Golfers ON [Current Game].CID = Golfers.CID) INNER JOIN Customers ON Golfers.GID = Customers.GID) ON Teachers.TID = Customers.TID
WHERE (((Customers.M)='None') AND ((Customers.GM)='None') AND ((Customers.Lessons)='No'));

Its a bit big

DELETE [Current Game].*, Customers.*, Golfers.*, Teachers.*, Customers.M, Customers.GM, Customers.Lessons, [Current Game].CID, [Current Game].[Date of game], [Current Game].[1st], [Current Game].[2nd], [Current Game].[3rd], [Current Game].[4th], [Current Game].[5th], [Current Game].[6th], [Current Game].[7th], [Current Game].[8th], [Current Game].[9th], [Current Game].[10th], [Current Game].[11th], [Current Game].[12th], [Current Game].[13th], [Current Game].[14th], [Current Game].[15th], [Current Game].[16th], [Current Game].[17th], [Current Game].[18th], [Current Game].Total, Customers.PID, Customers.Surname, Customers.[First Name], Customers.Title, Customers.DOB, Customers.Sex, Customers.GID, Customers.DSUFM, Customers.EDFM, Customers.DSUFGM, Customers.EDFGM, Customers.TID, Customers.[Phone #], Customers.Email, Customers.Photo, Golfers.GID, Golfers.CID, Golfers.Rank, Golfers.TAO8, Golfers.TW08, Golfers.TS09, Golfers.TSm09, Golfers.TA09, Golfers.TW09, Teachers.TID, Teachers.Title, Teachers.Surname, Teachers.[First Name], Teachers.[Phone #]
FROM Teachers INNER JOIN (([Current Game] INNER JOIN Golfers ON [Current Game].CID = Golfers.CID) INNER JOIN Customers ON Golfers.GID = Customers.GID) ON Teachers.TID = Customers.TID
WHERE (((Customers.M)='None') AND ((Customers.GM)='None') AND ((Customers.Lessons)='No'));