Hello All.
The database I have taken over has two tables called LookupSupplier and LookupManufacturer. Having been in charge of the database for a year or so, I can't see any instance why there needs to be two different tables, when a lot of the data is the same. I have created a new table called LookupCompany, combined the data from the two tables and removed the duplicates.
I am currently attempting to delete all of the relationships relating to the two redundant tables, and create new identical relationships with the LookupCompany table.
However when I am doing so, I get the following message:
I am trying to create a one to many relationship between the LookupCompany table and the Contracts table in my database. The relationship links the primary key CompanyName to the Contractor field.
Having gotten this message, I have been through all instances of Contractor in the Contracts table and verified that they all exist in the CompanyName field.
I am struggling to understand why it won't let me tick the referential integrity box.
Has anybody seen this before?
Thanks
The database I have taken over has two tables called LookupSupplier and LookupManufacturer. Having been in charge of the database for a year or so, I can't see any instance why there needs to be two different tables, when a lot of the data is the same. I have created a new table called LookupCompany, combined the data from the two tables and removed the duplicates.
I am currently attempting to delete all of the relationships relating to the two redundant tables, and create new identical relationships with the LookupCompany table.
However when I am doing so, I get the following message:
I am trying to create a one to many relationship between the LookupCompany table and the Contracts table in my database. The relationship links the primary key CompanyName to the Contractor field.
Having gotten this message, I have been through all instances of Contractor in the Contracts table and verified that they all exist in the CompanyName field.
I am struggling to understand why it won't let me tick the referential integrity box.
Has anybody seen this before?
Thanks