Cascading on delete

[mapat]

Hello,

I want to delete many records in a CASCADING way, meaning if I have a 1 to many relationship between 2 tbls, I want to delete some records on the 1 side of the relationship as well as their corresponding records on the many side of the relationship table. I know how to do this in SQL Server, but does ACCESS 2007 have a way to do this?

Thank you very much everyone.

 

[boblarson]

Set referential integrity in your database's relationships window and set the Cascade Deletes to YES.