Sub Form and Tables

[Jeff]

I have a Parts table that includes PartNumber, PartName and UnitPrice fields.
I also created a Parts Order Details table that includes the PartName and
UnitPrice fields, as well as an OrderNumber field. I want to be able to
select the PartName and UnitPrice from the Parts table to fill out these
fields in the Parts Order Details table. I can't seem to have it work when I
attempt to inset a Lookup Column. Help!!!

 

[ruralguy via AccessMonster.com]

Your Parts table should have a Primary Key field. I would suggest an
AutoNumber field. The you put the PK in the Order table and that is all.
Create a query that joins the Parts table with the Order table and join on
the common field and it will be as iff both tables are one. As soon as you
populate the FK field of the query the other field just appear as if by magic!
8^)