Selasa, 12 Juli 2016

RE: [MS_AccessPros] Relationship Definition

 

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.

 

 

Darrell

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, July 12, 2016 1:47 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Relationship Definition

 

 

I have 2 tables:

Product Class

Product

 

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.

 

Sarah


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)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Poskan Komentar