Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete queries-cascade (Access 1001)

    I was playing around with delete queries where the referential integrity was engaged and cascade delete was activated. All the books I have read states you put both the one and many side tables on the QBE. When I do that the query does not work. If I have only the one side on it works properly deleting from both tables. What is the proper way of doing a delete query with cascade delete engaged? Thanks Fay

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Delete queries-cascade (Access 1001)

    If you have a cascading delete set up, you only need the one side of the relationship. The related records will be deleted from the many side no matter what. If the tables are related but you don't have cascading deletes turned on, *then* you need both tables in the query.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •