J
junkaccount
I'm not even sure how to explain this but I'll try. I need help
pulling data from two tables based on results of a query. The set-up
is: TableMachineLoad contains data about all jobs processed by a
certain machine on a certain day. One machine will process many jobs
on any given date. TableMachineCycle contains data on the specific
process each machine performed on each day. Each machine will only run
one process per day. In my perfect little world, my user would run a
query and be prompted to enter a job number. The query returns all
data from TableMachineLoad based on the user's input. At the same
time, somehow, without further user input, information from
TableMachineCycle would be returned based on the data from FieldDate
and FieldMachine Number in TableMachineLoad.
Sample Table structure:
TableMachineLoad TableMachineCycle
FieldDate FieldDate
FieldMachineNumber FieldMachineNumber
FieldCustomer FieldProcessDetails
FieldJobName
FieldJobNumber
The data after running the query might look like this:
Date MachineNumber Customer JobName JobNumber ProcessDetails
12/5/05 1 ACME Widgets 001 Hold at 1200
The only way I know for the query to get the data for
FieldProcessDetails would be based on the values returned in FieldDate
and FieldMachineNumber, and I dont't know how or even if this can be
done. It would be best if all this information could be presented
within one query (or report). I have a general understanding of
relationships but this request sounds pretty high tech to me so I'm
not sure that I could grasp the process if it can even be done. Much
thanks to anyone who can consider this.
Jason
pulling data from two tables based on results of a query. The set-up
is: TableMachineLoad contains data about all jobs processed by a
certain machine on a certain day. One machine will process many jobs
on any given date. TableMachineCycle contains data on the specific
process each machine performed on each day. Each machine will only run
one process per day. In my perfect little world, my user would run a
query and be prompted to enter a job number. The query returns all
data from TableMachineLoad based on the user's input. At the same
time, somehow, without further user input, information from
TableMachineCycle would be returned based on the data from FieldDate
and FieldMachine Number in TableMachineLoad.
Sample Table structure:
TableMachineLoad TableMachineCycle
FieldDate FieldDate
FieldMachineNumber FieldMachineNumber
FieldCustomer FieldProcessDetails
FieldJobName
FieldJobNumber
The data after running the query might look like this:
Date MachineNumber Customer JobName JobNumber ProcessDetails
12/5/05 1 ACME Widgets 001 Hold at 1200
The only way I know for the query to get the data for
FieldProcessDetails would be based on the values returned in FieldDate
and FieldMachineNumber, and I dont't know how or even if this can be
done. It would be best if all this information could be presented
within one query (or report). I have a general understanding of
relationships but this request sounds pretty high tech to me so I'm
not sure that I could grasp the process if it can even be done. Much
thanks to anyone who can consider this.
Jason