query columns in a combo box in a table

[Gandalph067]

I have two tables that has Employee and provider.
Provider
ProvID
Provider_Name
Team

Employee
EmpID
Emp_Name
Team

The Team is a combo box look up in the table of Provider
Bound Column 1
Column count 3

I want to use a query to call the second column of the field team. I have tried Team.Column(1) and it doesn't recognize this like it would in me.comlumn(1)...

Any thoughts??

 

[PHV]

Why not simply use a JOIN in your query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886