In Visual Studio 2005 SP1,
I added a DataSet item into my project.
I added 3 tables from SQL that have data and relationships.
I added 2 lookup columns (lkp) to the DllVersions table in the dataset
[Project]
ProjectID
ProjectName
[Servers]
ServerID
ServerName
[DllVersions]
DllVersionID
ProjectID
ServerID
DllVersion
lkpServerName (not in SQL)
lkpProjectName (not in SQL)
I want the lkp Columns to return the Name from the associated ID in the
parent table.
So in the DataSet, I click properties and set the Expression for
lkpServerName to
Parent(FK_DllVe rsions_Servers) .ServerName
lkpProjectName to
Parent(FK_DllVe rsions_Projects ).ProjectName
I can preview the data for any table in the dataset and it's all there.
The code is working because it does not throw an exception. However, it
does not display any data in either of the lkp columns.
What's going on here?