Click here for image
Ok there are two files:
transaction file
and new car stock file
each file contains a field name called CarID
what i want the delete query to do is when the tranaction file-Car ID equals the New Car Stock-CarID the record containing the carID is deleted in the New Car Stock File
please help and i hope this make sense
thanks
Paul