i need some info on this, can anyone tell me how??
In the DB diagram, click on the relationship, open up the properties, make sure that the "Cascading Deletes" box is checked.<BR><BR>Yo ho ho and a bottle of rum.
it gives me an error like this :<BR><BR>delete statement conflicted with column reference constraint. The error occured in database incident, table "involvedpersonnel" column incidentid... i did what you said roger, but still error...