Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Unmatched Query Wizzard Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I built a query with Find Unmatched Query Wizzard

    z_tbl_RevTran_Master Without Matching tbl_RevTran_Detail

    Enforce referential integrity
    Cascade update related fields
    Cascade delete related records

    It displayed 58 records

    I selected and deleted them after acknowledging

  2. #2
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Unmatched Query Wizzard Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    are the two tables in the query shown and their key fields linked? I think you may need that if you want the actions taken in the query to carry over to the tables.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Find Unmatched Query Wizzard Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    The "Cascade delete related records" means that if you delete a master record, all related detail records will be deleted too. But you are looking for master records without detail records, so "Cascade delete related records" doesn't play a role here.

    You cannot delete directly from a Find Unmatched query, but for some reason Access doesn't indicate this. To delete, create a new query based on the tbl_RevTran_Master table, add the ID field, and enter the following in the Criteria line:

    In (SELECT [ID] FROM [z_tbl_RevTran_Master Without Matching tbl_RevTran_Detail])

    where ID is the name of the ID field. You can select records in this query and delete them, or change the query itself into a delete query.

  4. #4
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,877
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Unmatched Query Wizzard Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP

    Thank you

Posting Permissions

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