resident
جمعه 23 تیر 1396, 22:54 عصر
سلام
دستور زیر رو نوشتم که relation بین دو جدول رو برقرار کنم
ALTER TABLE [Cost] WITH CHECK ADD CONSTRAINT [FK_Cost_CostSubCategory] FOREIGN KEY([CostSubCategoryID])
REFERENCES [CostSubCategory] ([CostSubCategoryID])
GO
ALTER TABLE [Cost] CHECK CONSTRAINT [FK_Cost_CostSubCategory]
GO
خطای زیر رو دارم.
There are no primary or candidate keys in the referenced table 'CostSubCategory' that match the referencing column list in the foreign key 'FK_Cost_CostSubCategory'.
.
چرا؟
دستور زیر رو نوشتم که relation بین دو جدول رو برقرار کنم
ALTER TABLE [Cost] WITH CHECK ADD CONSTRAINT [FK_Cost_CostSubCategory] FOREIGN KEY([CostSubCategoryID])
REFERENCES [CostSubCategory] ([CostSubCategoryID])
GO
ALTER TABLE [Cost] CHECK CONSTRAINT [FK_Cost_CostSubCategory]
GO
خطای زیر رو دارم.
There are no primary or candidate keys in the referenced table 'CostSubCategory' that match the referencing column list in the foreign key 'FK_Cost_CostSubCategory'.
.
چرا؟