Access: Now Playing (Page 1) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44

 

Database Tools -> Edit Relationships

Joining the Tables

If you enable Referential Integrity, you cannot delete a record from a primary table if matching records exist in a related table. For example, you cannot delete a customer from tblCustomer if there are rentals sold to that customer in tblMoviesRented.

 

You can delete a primary record and all related records by choosing to Cascade Delete Related Records check box.
   

 

  Microsoft Access 2007 Exam 77-605 Topic: 1. Structuring a Database

  1.2.2.   Modify relationships: Define join type (Not ad-hoc joins created in the query editor)