Autofilling information based on 2 other fileds

  • Thread starter Thread starter Michele E
  • Start date Start date
M

Michele E

Hi.

I have created a form for entering production data. I have a query which
will autofill an expected production value (standard) based on the product
being produced. This is working well. However, I now need to autofill the
standard field not only based on the product, but also on the machine it is
being produced on. Is it possible to create a lookup table (or query) that
will view 2 different inputs in a form and then autofill another field's
value?
Machine Product Standard
example: A1 soda 100 (bottles per minute)
B2 soda 125
A1 water 150
B2 water 175

If Machine and Product are inputs into my form and Standard will be pulled
from a lookup query, how can I get the Standard to return a value of 100
(look up) when Machine = A1 and Product = Soda
 
May we assume that there is a 1 to 1 relationship between Machine, Product
and Standard? In other words, for every Machine/Product combination will
there be one and only one value for Standard? If so, then why not simply
store the value of Standard in the same table as Machine and Product and
avoid doing a lookup altogether.
 
Back
Top