Linking Tables
-
I've got 2 tables: Province and Client When I link Province with client i get the ff message 'Province' table saved successfully 'Client' table - Unable to create relationship 'FK_Client_Province'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Client_Province". The conflict occurred in database "test", table "dbo.Province", column 'Province'. karabo
-
I've got 2 tables: Province and Client When I link Province with client i get the ff message 'Province' table saved successfully 'Client' table - Unable to create relationship 'FK_Client_Province'. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Client_Province". The conflict occurred in database "test", table "dbo.Province", column 'Province'. karabo
not got your query in full. can you please give the sql statement reselted in this error. along with the 1. parent able and chield table 2. primary keys on the tables however what i under stook is province is parent and client is chield if so one column like provienceID should be primary key in province table and in client table's provienceID can refer to provience table
Regards KP