Query lookups when data is entered.

[Guest]

I am working on a parts database, where i have two tables...main parts table,
and parts ordered table. In the parts table, I have the part number,
quantity, and location stored. When I am entering the parts number into the
parts ordered table, is there a way to have Access automatically enter the
location where that part is stored? I already know how to link fields in
seperate databases so I can pick from a drop-down list, and that's not what I
want it to do. Can anyone help?

 

[John Vinson]

I am working on a parts database, where i have two tables...main parts table,
and parts ordered table. In the parts table, I have the part number,
quantity, and location stored. When I am entering the parts number into the
parts ordered table, is there a way to have Access automatically enter the
location where that part is stored? I already know how to link fields in
seperate databases so I can pick from a drop-down list, and that's not what I
want it to do. Can anyone help?

The Parts Ordered table should almost certainly NOT contain the
location. The location of a part is an attribute of the part, not of
an order. Could you explain why you feel that it's necessary to store
this information redundantly?

You should be using a Form to do this (not a table datasheet) in any
case; you can *display* the location on the Form by putting the part
number and location in the RowSource of a parts combo box, and putting
a textbox on the form with a control source like

=cboPartNo.Column(n)

where cboPartNo is the name of the combo box and (n) is the *zero
based* index of that field in the row source query.

John W. Vinson[MVP]