Auto-fill fields

K

khaz19

I am setting up a parts inventory database and when we order parts, we have
to fill in all the information that is in the respective record. Is there a
way to just enter the part number, and them configure Access to pull the rest
of the information for that part from the main table and enter it into the
order table?
 
B

BCampbell

You probably don't want to do what you think you want to
do! Your order table does not need (and should not have!!)
part information in it. Only the part number or ID is
needed. If you need the part information, for reporting,
or invoicing, etc, use a query to join the order table and
the part table and pull in the fields you need for the
invoice or whatever.

HTH!
Bonnie
 
J

John Vinson

I am setting up a parts inventory database and when we order parts, we have
to fill in all the information that is in the respective record. Is there a
way to just enter the part number, and them configure Access to pull the rest
of the information for that part from the main table and enter it into the
order table?
Click to expand...

It is neither necessary nor good design to copy the data into the
Order table. The ONLY field you need in the Order table is the unique
Partnumber.

To print an order, or to display it onscreen, use a query joining the
Order table to the Parts table. You're using a relational database -
use it relationally! See the Northwind sample database's Order
application for an example of how this can be done.

John W. Vinson[MVP]
 
Top