Dear experts, I have 7 tables: tblWeather, tblFactors, tblCondition, tblVehicle, tblDriver,tblEvent, tblInsurance tblWeather has: weatherID int pk, weatherDesc varchar(50) tblFactors has: factorsID int pk, factorsDesc varchar(50) tblCondition has: conditionID int pk, ConditionDesc varchar(50) tblInsurance has: insuranceID int pk identity, insuranceCo varchar(50), PolicyNumber varchar(50) tblEvent has several fields including: eventID pk identity int, factorsID (fk from tblFactors) weatherID (fk from tblWeather) tblVehicle has several fields including: insuranceID (fk from tblInsurance) eventID (fk from tblEvent) tblDriver has several fields including: driverID int pk identity, eventID (fk from tblEvent), conditionID (fk from tblCondition) What has is that whenever a record is created, naturally, you can perform a join to display records that a user wants to see. For instance, a user might want to see the name of a driver, the vehicle the driver is driving, the insurance on the vehicle, the factors contributing an accident (if one occurs), the condition of the driver (from tblCondition), etc. my question is, if a user enters incorrect info, or even if info entered is correct but the user wants to delete this info, how can I do this giving the table listings above? Please your assistance is greatly appreciated. I know that I can delete info entered on tblEvent but I need all records associated with a particular eventID to be deleted also.