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