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