Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No Ref Integrity (2000)

    Hello, I have been set a task to report on data held in a application with no referencial integrity, there are now many activated records in the one part of the relation but none in the many, how can I run a query to produce these records and thus delete.

    Many thanks Darren.

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

    Re: No Ref Integrity (2000)

    Try the Find Unmatched Query Wizard:
    - Activate the Queries section of the Database Window.
    - Click New
    - Select Find Unmatched Query Wizard.
    - Follow the instructions.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No Ref Integrity (2000)

    Hans, you have endied my frustration. 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
  •