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

    Integrity (2000)

    Hello, have inherited a d/b where ref integ was not enforced. Records have been activated in the one side of a relation but not in the all important many. I now want to run a query to delete these incomplete records. Trouble is when i run the query it returns no records. Any suggestions please.

    Thanks Darren.

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

    Re: Integrity (2000)

    Sorry, but I don't think that makes sense. Referential integrity is to keep you from having orphans in the "many" side without a parent record in the "one" side. If you already have that situation, what is the problem you're trying to solve?
    Charlotte

  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: Integrity (2000)

    Hi Charlotte, in my parent table i have a records activated, but when I expand down to the child there is no activated record.

    Thanks Darren

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

    Re: Integrity (2000)

    Yes, but what is the problem with that? Referential integrity insures that there will be no child record without a parent. It does not insist on a child record. If no child record was created, referential integrity is still satisfied, since you have to have a parent *before* you can create a child record.

    As far as "expand down" goes, are you talking about subdatasheets? They have nothing to do with referential integrity except that they show up automatically if there is a parent child relationship between two tables. The absence of a child record doesn't indicate a problem.
    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
  •