Two table double lookup

[zorro19s]

I am forming one table2 out of table1. I want to have the option to select a part# from the list in table1 and the description from table1 shows up in table2. Or select description in table2 from table1 and part# shows up in table2? Please Help me with this?

 

[PaulF]

you might want to spend a little time looking at this article in the MS Knowledge Base
Database Normalization Basics
Article Q100139

http://support.microsoft.com/support/kb/articles/Q100/1/39.asp

PaulF

 

[Tmconsult]

if the part# is a primary key for the part then you could use the DLookup function which will lookup the description that is associated with that part#. Usually after you enter the part number you need to refresh the data to look it up. YOu could do this be writing the code using lost focus for that text and once you hit enter or tab it will look up the description the code is (name of field in form) = DLookup("[Description]", "[Form1]", "[Form1]![Part#]=[forms]![Form2]![part#]&quot