Hello All,

I wonder if anyone can please help.

I am using a GridView and DetailsView in ASP.NET 2.0, linked to a MS-SQL database. Let's say the database has 2 tables, Employees and Departments.

The Employees table has reference to the Department an employee works in, by referring to the 'Foreign Key' value, DeptID, that links to the Departments table.

However, I am struggling to display the actual text value of the Department, e.g. IT, HR, Accounts, Marketing, etc, and instead only managing to display the DeptID number, e.g. 1, 2, 3, etc.

Does anyone have any ideas on how to tackle this problem?

I'm a total novice at ASP.NET so please be gentle. Also, I'm using VB not C#.

Thanks in advance, Ash (UK)