Hello,
I am currently working on a database project in which I am having some trouble on! When creating relationships, I get the following error message:
"Microsoft Access cannot create this relationship and enforce referential integrity" when attempting to create a relationship between Symptoms/Diagnosis.Diagnosis AND Diagnosis.Diagnosis.'
When attempting to change Diagnosis as the FK in Symptoms/Diagnosis, I get the following message:
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The database has been attached. Thanks!
I am currently working on a database project in which I am having some trouble on! When creating relationships, I get the following error message:
"Microsoft Access cannot create this relationship and enforce referential integrity" when attempting to create a relationship between Symptoms/Diagnosis.Diagnosis AND Diagnosis.Diagnosis.'
When attempting to change Diagnosis as the FK in Symptoms/Diagnosis, I get the following message:
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The database has been attached. Thanks!
0 commentaires:
Enregistrer un commentaire