If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
STORE multiple values from a 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. |
#3
|
|||
|
|||
STORE multiple values from a 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. |
Thread Tools | |
Display Modes | |
|
|