Inserting values based on foreign key

Posted by Self-innovator under ASP.NET on 1/7/2012 | Points: 10 | Views : 1866 | Status : [Member] | Replies : 0
Dear all,
I've three table namely tbCompanyData,tbQnMst,tbQnRating
and this is my table struc..
1)tbCompanyData->Columns->
ID(PK,int,Not null)
CompanyName (varchar(100),not null)
EmailID(varchar(100),not null)
2)tbQnMst->columns->
1.Code(PK,tinyint,notnull)
2.Description (varchar(200)notnull)

3)tbQnRating->columns->
1.ID(PK,FK,int,not null)
2.QnCode(PK,FK,tinyint,notnull)
3.Rating (tinyint,not null)

I want to store the values values in tbCompanyData based on Questionmaster with QuestionCode and Rating based on rating.If you dont't understand pls go through the design of 3 table structure and provide the solution to insert the values in tbCompanyData based on QuestionCode and Rating.

Problem:To insert the values based on foreign key

Join Hands Change lives
Thanks & Regards
Straight Edge Society



Responses

(No response found.)

Login to post response