Seeing Table Values

S

StevieD

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?
 
M

Marshall Barton

StevieD said:
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
 
S

StevieD via AccessMonster.com

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 said:
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
 
M

Marshall Barton

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]

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 said:
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

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?
 

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