I have two table is a database named
=> Region(RegionID int PK, RegionName, RegionDesc) and
create table Region (RegionID int not null primary key, RegionName varchar(30) not null, RegionDesc varchar(100) null);
AND
=> ArchSite(SiteID int PK,RegionID int FK, SiteName,SiteDesc,SiteStreet,SiteLandmark,SiteCity,SitePincode,SiteSteate,SiteCountry )
create table ArchSite1
(
SiteID int not null primary key, RegionID int not null
foreign key references Region(RegionID), SiteName varchar(20) not null, SiteDesc varchar(200)
, SiteStreet varchar(50), SiteLandmark varchar(100), SiteCity varchar(30) not null, SitePincode int not null
, SiteState varchar(30) not null, SiteCountry varchar(30) not null)
I have inserted 10 records in Region Table having primary key 1,2,3...10
now when I try to insert record in Site Table having records like
insert into ArchSite values(1,1,'Ganga Pallaace','Row houses and banglows',East Road', 'Bus Stop',' Chenni ', 411010 ,' Gujrat ','England');
I;m getting error like .
.
.
.
.
.Msg 547, Level 16, State 0, Line 2
The INSERT statement conflicted with the FOREIGN KEY constraint "FK__ArchSite__Regio__02084FDA". The conflict occurred in database "eCMS", table "dbo.Region", column 'RegionID'.
The statement has been terminated.
....
Please Help me out...Thank u in advance