Seeing Table Values

Im absolutely useless at using Access. I was wondering if someone knew how to
assist me witht he following problem im having.

I have a Table called 'Despatch Status' which contains 3 fields.
'MachineCodeA', MachineCodeB' and MachineCodeC'. Each of these fields is a
dropdown list which is populated from another Table called 'MachineCode'. In
this table theres are two fields entitled ID (primary key) and MachineCode
(the actual values I require).

I also have a Report (used to print a date range) called 'Live Orders'. On
this report I need to show the values of MachineCodeA etc.. However, its
simply pulling in the ID number instead of the Machine Code value that I
require?

I hope that makes sense. Any ideas?

StevieD wrote:

Im absolutely useless at using Access. I was wondering if someone knew how to
assist me witht he following problem im having.

I have a Table called 'Despatch Status' which contains 3 fields.
'MachineCodeA', MachineCodeB' and MachineCodeC'. Each of these fields is a
dropdown list which is populated from another Table called 'MachineCode'. In
this table theres are two fields entitled ID (primary key) and MachineCode
(the actual values I require).

I also have a Report (used to print a date range) called 'Live Orders'. On
this report I need to show the values of MachineCodeA etc.. However, its
simply pulling in the ID number instead of the Machine Code value that I
require?


Create a new query. Add the Despatch Status table, then add
the 'MachineCode' table three times. Then check to make
sure the connection lines between the tables are from
[Despatch Status].MachineCodeA to MachineCode.ID,
[Despatch Status].MachineCodeB to MachineCode_1.ID and
[Despatch Status].MachineCodeC to MachineCode_2.ID

Now you can drag the MachineCode field from each of the
three tables to the query's field list. You should alias
each of these fields to make it easier to keep track of
which is which:

Field McodeA: MachineCode
Table MachineCode

Field McodeB: MachineCode
Table MachineCode_1

Field McodeC: MachineCode
Table MachineCode_2

--
Marsh
MVP [MS Access]

Hi, thanks. But I still seem to be getting the ID values as opposed to the
other field.
Could I be missing something or theres something else conflicting?


Marshall Barton wrote:
Im absolutely useless at using Access. I was wondering if someone knew how to
assist me witht he following problem im having.
[quoted text clipped - 9 lines]
simply pulling in the ID number instead of the Machine Code value that I
require?

Create a new query. Add the Despatch Status table, then add
the 'MachineCode' table three times. Then check to make
sure the connection lines between the tables are from
[Despatch Status].MachineCodeA to MachineCode.ID,
[Despatch Status].MachineCodeB to MachineCode_1.ID and
[Despatch Status].MachineCodeC to MachineCode_2.ID

Now you can drag the MachineCode field from each of the
three tables to the query's field list. You should alias
each of these fields to make it easier to keep track of
which is which:

Field McodeA: MachineCode
Table MachineCode

Field McodeB: MachineCode
Table MachineCode_1

Field McodeC: MachineCode
Table MachineCode_2


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200511/1

Please post a Copy/Paste of the query's SQL view.

Let's try to reduce the confusion by leaving the report out
of the problem. Just open the query from the query design
window ans see if it contains the desired data. The report
may just be referring to the wrong field names or something
that's only fogging the problem.
--
Marsh
MVP [MS Access]


StevieD via AccessMonster.com wrote:
Hi, thanks. But I still seem to be getting the ID values as opposed to the
other field.
Could I be missing something or theres something else conflicting?


Marshall Barton wrote:
Create a new query. Add the Despatch Status table, then add
the 'MachineCode' table three times. Then check to make
sure the connection lines between the tables are from
[Despatch Status].MachineCodeA to MachineCode.ID,
[Despatch Status].MachineCodeB to MachineCode_1.ID and
[Despatch Status].MachineCodeC to MachineCode_2.ID

Now you can drag the MachineCode field from each of the
three tables to the query's field list. You should alias
each of these fields to make it easier to keep track of
which is which:

Field McodeA: MachineCode
Table MachineCode

Field McodeB: MachineCode
Table MachineCode_1

Field McodeC: MachineCode
Table MachineCode_2


StevieD via AccessMonster.com wrote:
Im absolutely useless at using Access. I was wondering if someone knew how to
assist me witht he following problem im having.
[quoted text clipped - 9 lines]
simply pulling in the ID number instead of the Machine Code value that I
require?