I have 3 tables as below.
Terms (TID, Tname)
TermConditions (TCID , FK_TID, TCName)
SelectedTermsAndConditions. (RowID, FK_TID, FK_TCID , SomeDescription)
I have a dataset.xsd and i have set relation between Terms and TermConditions tables. (Lets say name of Relation is "TTC")
In a Winform, i have a grid whose datasource = SelectedTermsAndConditions.
I added Two Lookup columns to display TName and TCName for FK_TID, FK_TCID colums respectively
I set their datasource as below.
FK_TID.DataSource = Terms
FK_TCID.DataSouce = Terms.TTC (The Relation).
When the grid is displayed only for 1st row of SelectedTermsAndConditions I get TName and TCName correctly.
From 2nd Row onwards TCName remains null.
(Note when I try to edit, both lookupcolumns as a dropdownbox appear to behave normally. meaning when i choose TName, it filters and displays child values in TCName lookupcolumn). but somehow it looks like while displaying grid it is not able to get child values for each row.
Hoping my above explaination was clear to understand problem scenario.
-Lee.
Terms (TID, Tname)
TermConditions (TCID , FK_TID, TCName)
SelectedTermsAndConditions. (RowID, FK_TID, FK_TCID , SomeDescription)
I have a dataset.xsd and i have set relation between Terms and TermConditions tables. (Lets say name of Relation is "TTC")
In a Winform, i have a grid whose datasource = SelectedTermsAndConditions.
I added Two Lookup columns to display TName and TCName for FK_TID, FK_TCID colums respectively
I set their datasource as below.
FK_TID.DataSource = Terms
FK_TCID.DataSouce = Terms.TTC (The Relation).
When the grid is displayed only for 1st row of SelectedTermsAndConditions I get TName and TCName correctly.
From 2nd Row onwards TCName remains null.
(Note when I try to edit, both lookupcolumns as a dropdownbox appear to behave normally. meaning when i choose TName, it filters and displays child values in TCName lookupcolumn). but somehow it looks like while displaying grid it is not able to get child values for each row.
Hoping my above explaination was clear to understand problem scenario.
-Lee.