Relationship & Imported Data

[Rahja]

I am importing from a text file two sub tables to the Access project. I am attempting to build a relationship where the Main table has a number, (example 1,2,3...etc.) and that number corresponds with a label in the sub folder. However, I have attempted every which way but loose and I know I am missing a step some where but not sure where.

Here is the situation:

Sub table has column names such as: ID & Name
Main table has column that correesponds with ID but I want to show the Name.

Please help, I am running out of patience.....and time..LOL

Raj

 

[melinda]

first u should set the relation ship between those table.
and then u can retrieve Name using query.
a very simple way....

ex.
SELECT detail.EmpId, detail.EmployeeName, master.Departement
FROM master INNER JOIN detail ON master.DeptId = detail.DepId;

 

[melinda]

first u should set the relation ship between those table.
and then u can retrieve Name using query.
a very simple way....

ex.
SELECT detail.EmpId, detail.EmployeeName, master.Departement
FROM master INNER JOIN detail ON master.DeptId = detail.DepId;


hope this can help
regards