STORE multiple values from a lookup table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
My database will record and report production information from a manufacturing operation.
I need to lookup product information per machine and store the information
Click to expand...
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
Click to expand...
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
Click to expand...
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 said:
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.
Click to expand...
 
Back
Top