Hello,

I am using an ADODC to access my Access DB. I have the datagrid retrieving the fields, but now I need to create a relationship to join two of my tables together to get the correct information shown on my database through my program (not create the relationships through Access).

I typed...
select * from tblEmployees
Inner Join tblLocations On
tblEmployees.fldLocationID = tblLocations.fldLocationID

in the property page/recordsourve tab/command text box.

Now I need it to show the correlating Location Name instead of the Location ID in the column. What is the SQL code to do this?

Thank a mill, Tasha

Hi, try:
select e.Name, e.Address, l.LocationName
from
tblEmployees e INNER JOIN tblLocations l ON (e.fldLocationID=l.fldLocationID)

You either have to specify all fields in the SELECT, or use Retrieve Fields method on the grid and hide the field you don't want.

Hope this helps,
Kieron

____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)