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.
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (1)|