Delete all related posts

I have a database with tables:

Party
Arrivals
Departures

if i delete a post in Party i want the related posts in arrivals and departures to be deleted aswell,
they are related with Party.ID
Im working in Microsoft Access.

Thanks
Robert
illionAsked:
Who is Participating?
 
waelothmanConnect With a Mentor Commented:
open the realation digram in the Access make the relation between table and choose "cascade deleted related record "
0
All Courses

From novice to tech pro — start learning today.