Query results from joined table

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.
 
A

Abe

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.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top