Form/Table AutoFill

K

Kneppy

I have a list of parts by different manufacturers. Each manufacturer has its
own "reference" number. How can I get the form to fill in this number from a
query/table automatically when the manufacturer's name is selected from a
list box?
 
D

Devin

I would suggest you create a separate table consisting of your vendors and
the reference number then create a relationship between your current table
and the new vendor information table. Then use a query to pull the
information in. Open both tables in the query screen. When you open both
tables in the query screen you will see the line for the relationship. Pull
the information that you need from your current table then pull the reference
number from you new vendor information table. Use this query to create your
form. This should do it.
 
Top