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
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