In order to enforce referential integrity, each row in the child table, Product, MUST relate to a record in the parent table, Product Class. You can still create a relationship. You just can't apply referential integrity.
I have 2 tables:
The Product table has a field Product Class that relates to the Product Class table. This field in the Product table is optional.
I am trying to define a Relationship with 'referential integrity' between the Product Class and the Product table, but because I have records in the Product table that dont have the Class filled in, I am getting a message 'Product violates referential integrity'. Is there any way around this?. I have tried all Join Types but I am getting the same message on all of them.
Thanks for your answers.
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
Posted by: "Embrey, Darrell" <DEmbrey@bcbsm.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|