I have a table where data already resides. I am trying to setup a foreign key but got the following error message
'tblOrgRegistrations' table saved successfully
- Unable to create relationship 'FK_tblOrgHours_tblOrgRegistrations'.
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tblOrgHours_tblOrgRegistrations". The conflict occurred in database "CAPRegistration", table "dbo.tblOrgRegistrations", column 'RegID'.
Is it possible to setup a foreign key while data is already present for RegID?