Datagrid relationships

  • Thread starter Thread starter dallasfreeman
  • Start date Start date
D

dallasfreeman

How do you make a datagrid show an additional row under each row with
data connected by a relationship to another table (as like when you
create a relationship between tables in Access).

I have two tables
1
tblSurvey
Survey_ID
Q1
Q2
Q3

2
tblSurveyExtra
QuestionID
SurveyID
Answer

I want to be able to view the tblSurveyExtra.Answer for each Survey_ID
from tblSurvey
 
Dallas,

In a winform you cannot.
In a webpage I thought it was possible but I don't know how.

Therefore for others who maybe know this, what kind of datagrid

Cor
 
Have you considered creating a view in SQL that joins the two tables on
Survey_ID and then using that view as your data source for your
datagrid, or are specifically wanting the data only to appear when the
user clicks on the survey data?

Hope this helps,

dkb
 
Back
Top