I have two tables on an MS Access database. One call EMPLOYESS and the other
one call ORDERS. I'm using ASPX (.net ) to show the contents of ORDER . I
could see all the data on the ORDER page on the web browser without any
problem. Except the EMPLOYEEid field which is a primary key filed from
EMPLOYESS table linked to ORDER table (I can see the employee name fine on
Access). But when I preview that order table I see the Primary key value
instead of Employee names so instead of seeing Bill Gate, I see his Primary
key value as 1.

This is how I linked up the Employess Name to ORDER Table in access:



SELECT DISTINCTROW Employees.EmployeeID, [LastName] & ", " & [FirstName] AS
Name

FROM Employees

ORDER BY Employees.LastName, Employees.FirstName;



Any help is welcome.



Anna X, UK