STORE multiple values from a lookup table

[beller]

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.

 

[Duane Hookom]

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

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.

 

[beller]

Thanks, this method worked well.

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



in a daily production table. MachineID will be a foreign key in the daily
production table.
to store the product information in the production table instead of just the
MachineID foreign key.
permanently store them in another table so that they will not change with
changes made to the lookup table.