Cascade delete selectively NOT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I delete a record (via form button) all the related records in other
tables in this defined relationship delete OK except from one table. I
checked, enforced referential = yes, and both cascades checked yes, as in all
pertinent tables. The table not deleting is a one to many relationship as
are others that are successful. It appears that this table is set up just
like the others, the key field is the same data type in each, but this one
table won't take out the record(s).

Is there a remedy? Is there an alternative -- easy? I am not a pro.
 
Hey Chris, are you certain there is a relationship between the table where
the delete occurs and the table where the records are not deleted? Check this
by:

Tool-->Relationships-->Show All Relationships
 
Back
Top