relationship issue in another table

Question

I am new in database I am trying to servicename(tbl_service) store in another table(tbl_qetintouch) but before I want to give relationship between them but give an error table data: error image: table image: when I am trying to give referance then give an error I want to show dropdownlist servicename data in getintouchform and store the servicename in getintouch table help

Mageshwaran R · Answer

Hi remdir, I'm soved your problem, please try this query: Note : Remove SpecialCharacters from tbl_service table .Ex(-,/) CREATE TABLE tbl_qetintouch ( getintouchid int identity(48,1), Name varchar (50), emailid Nvarchar(50), phonenumber bigint , description nvarchar(50), constraint PK_tbl_qetintouch primary key (getintouchid) ) insert into tbl_qetintouch ( Name , emailid, phonenumber, description ) select Name = 'alex' , emailid= 'alex@gamil.com' , phonenumber=+911234567890, description= 'good yiim' insert into tbl_qetintouch ( Name , emailid, phonenumber, description ) select Name = 'tons' , emailid= 'tons@gamil.com' , phonenumber=+91123456789, description= 'gekkis btis sid' insert into tbl_qetintouch ( Name , emailid, phonenumber, description ) select Name = 'hids' , emailid= 'hids@gamil.com' , phonenumber=+93123456789, description= 'hello i want create static website' insert into tbl_qetintouch ( Name , emailid, phonenumber, description ) select Name = 'hs' , emailid= 'hs@gamil.com' , phonenumber=+931234569, description= 'hello' create table tbl_service ( serviceid int identity(48,1) constraint FK_tbl_service foreign key references tbl_qetintouch(getintouchid), serviceName varchar (100) ) insert into tbl_service(serviceName) select serviceName= 'Mobile Application Deveploment' insert into tbl_service(serviceName) select serviceName= 'Web Development' insert into tbl_service(serviceName) select serviceName= 'customized open source' insert into tbl_service(serviceName) select serviceName= 'consulting coulds and devep' select tbl_qetintouch. Name , tbl_qetintouch.emailid, tbl_qetintouch.phonenumber, tbl_qetintouch.description, tbl_service.serviceName from tbl_qetintouch inner join tbl_service on tbl_qetintouch.getintouchid=tbl_service.serviceid

Kiran Mohanty · Answer

HI, You don't need service name column in getintouch table. Just add service id(fk) column and reference it. Before defining foreign key, update it with some default value.

nisku remdir · Answer

Hello Kiran your means service id(fk) and service name(normal field) both in getintouch table?

nisku remdir · Answer

hello sachin both service id and getintouch id is primary key still facing same error?

Kiran Mohanty · Answer

Let me clarify my understanding. You have a drop down and you are populating data from tbl_service table. On some data save you wish to save service name reference in tbl_qetintouch. If so, please define a column "serviceId" in tbl_qetintouch and make it as foreign key with reference to "serviceId" column in tbl_service. Note:- you have predefined data in tbl_qetintouch and hence "serviceId" in tbl_qetintouch will have Null value by default. Update it to some default "ServiceId" value and then try creating foreign key reference.

Sachin Singh · Answer

Check Serviceid is primary key in service table and getinTouchId is primary key in GetinTouch table Then you will not face error.

nisku remdir · Answer

your means service id(fk) and service name(normal field) both in getintouch table? I am right or wrong?

tayyab hussain · Answer

Use ServiceId as forign Key in tbl_qetintouch table.