&nbsp;<BR>Say I&#039ve got two tables with a one-to-many relationship between them on a field called IDItem. If i delete an entry in the table with IDItem as the primary key, i would also like the other table to have the corresponding rows deleted.<BR><BR>In Access i set the relationship to be "cascade on delete", but in SQL how do i do this???<BR><BR>thanks.