Results 1 to 2 of 2

Thread: relationships

  1. #1
    Join Date
    Apr 2003
    Posts
    48

    relationships

    I am getting an errror when trying to relate a table, enforce referential integrity are violated on the many side of a relationship what does that mean exactly.

    Rob

  2. #2
    Join Date
    Feb 2003
    Posts
    102
    I don't think it's got anything to do with polygamy.

    It means that there are foreign key values that cannot be found in the parent table (remember you can have Nulls ie a child doesn't HAVE to have a parent, just each child with a key must have that key in the parent table).


    Eg

    Parents
    PID
    1
    2
    3

    Child
    CID PID
    1 1
    2 1
    3 2
    4 3
    5 3
    6 4

    Assuming
    Parent.PID is a PK
    Child.CID is a PK
    Child.PID is FK referencing Parent.PID

    the record CID = 6 violates referential integrity.

    Peter

Posting Permissions

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