STORE multiple values from a lookup table

My database will record and report production information from a manufacturing operation.
I need to lookup product information per machine and store the information in a daily production table. MachineID will be a foreign key in the daily production table.
However, the product information for each machine will change, so I need to store the product information in the production table instead of just the MachineID foreign key.
I want to automatically lookup multiple values from one table and permanently store them in another table so that they will not change with changes made to the lookup table.

When I must do this, I usually have the information as columns in a combo
box. Then in the After Update event of the combo box, use code like:
Me.txtProdDescription = Me.cboProdID.Column(2)

--
Duane Hookom
MS Access MVP


"beller" wrote in message
...
My database will record and report production information from a
manufacturing operation.
I need to lookup product information per machine and store the information
in a daily production table. MachineID will be a foreign key in the daily
production table.
However, the product information for each machine will change, so I need
to store the product information in the production table instead of just the
MachineID foreign key.
I want to automatically lookup multiple values from one table and
permanently store them in another table so that they will not change with
changes made to the lookup table.

Thanks, this method worked well.

"Duane Hookom" wrote:

When I must do this, I usually have the information as columns in a combo
box. Then in the After Update event of the combo box, use code like:
Me.txtProdDescription = Me.cboProdID.Column(2)

--
Duane Hookom
MS Access MVP


"beller" wrote in message
...
My database will record and report production information from a
manufacturing operation.
I need to lookup product information per machine and store the information
in a daily production table. MachineID will be a foreign key in the daily
production table.
However, the product information for each machine will change, so I need
to store the product information in the production table instead of just the
MachineID foreign key.
I want to automatically lookup multiple values from one table and
permanently store them in another table so that they will not change with
changes made to the lookup table.