Query results from joined table

  • Thread starter Thread starter Abe
  • Start date Start date
A

Abe

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"
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.
Click to expand...


.
Click to expand...
 
Back
Top