Query results from joined table

Maybe I don't understand table relationships,etc but I'm
not getting what I expect in my query.
I created a table to store equipment information:
tblEquip
EquipID - (PK)Autonumber
EquipName

and a table to store manufacturing information
tblMfg
Part# - (PK)
EquipName
RunDate
etc.......

Then I created a form for data entry with a dropdown
combobox for EquipID: SELECT [tblEquip].[EquipID],
[tblEquip].[EquipName] FROM tblEquip;
Bound Column = 1

When I run a query against tblMfg I want to see the
EquipName but I'm getting the EquipID instead. Do I need
to include the tblEquip in my query? or are my table
relationships wrong. Currently it is a 1-Many linking
EquipId and EquipName. Help! this is my first dB and it's
not going very well out of the gate.

Set following properites of combo box
Column Count = 2
ColumnWidth = 0";1"
"Abe" wrote in message
...
Maybe I don't understand table relationships,etc but I'm
not getting what I expect in my query.
I created a table to store equipment information:
tblEquip
EquipID - (PK)Autonumber
EquipName

and a table to store manufacturing information
tblMfg
Part# - (PK)
EquipName
RunDate
etc.......

Then I created a form for data entry with a dropdown
combobox for EquipID: SELECT [tblEquip].[EquipID],
[tblEquip].[EquipName] FROM tblEquip;
Bound Column = 1

When I run a query against tblMfg I want to see the
EquipName but I'm getting the EquipID instead. Do I need
to include the tblEquip in my query? or are my table
relationships wrong. Currently it is a 1-Many linking
EquipId and EquipName. Help! this is my first dB and it's
not going very well out of the gate.

Thank you

-----Original Message-----
Set following properites of combo box
Column Count = 2
ColumnWidth = 0";1"
"Abe" wrote in
message
...
Maybe I don't understand table relationships,etc but I'm
not getting what I expect in my query.
I created a table to store equipment information:
tblEquip
EquipID - (PK)Autonumber
EquipName

and a table to store manufacturing information
tblMfg
Part# - (PK)
EquipName
RunDate
etc.......

Then I created a form for data entry with a dropdown
combobox for EquipID: SELECT [tblEquip].[EquipID],
[tblEquip].[EquipName] FROM tblEquip;
Bound Column = 1

When I run a query against tblMfg I want to see the
EquipName but I'm getting the EquipID instead. Do I need
to include the tblEquip in my query? or are my table
relationships wrong. Currently it is a 1-Many linking
EquipId and EquipName. Help! this is my first dB and
it's
not going very well out of the gate.


.