Table Relationship Question?

[Randy]

Whenever I set up a relationship between a main table and a child table
and I want to delete records in the main table I also want it to delete
the corresponding records in the child table.

How do I make that happen?

 

[Rick B]

Right click on your relationship arrow and EDIT the relationship. then turn
on "cascade delete".

 

[Randy]

Rick

When I went in to set referential integrity I got a message that I
could not implement referential integrity because of records in the
table. Is there some way get around it without deleting the data?

 

[Randy]

Rick

When I went in to set referential integrity I got a message that I
could not implement referential integrity because of records in the
table. Is there some way get around it without deleting the data?

 

[Rick B]

Are you sure it said this was because of records? Or did it say that you
could not set it because certain data did not adhere to referential
integrity?

To turn it on, the tables must contain all matching data first. If there
are records in your table that break the rules, then you can't turn it on.

 

[Guest]

Run an unmatched query to find which ones are not in the main table and add
them.