-
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
-
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
-
Forum Rules
|
|