Pulling Info from a different Table/Query

[vepz]

I have a table where I enter a part number and quantity to track production. I have a query that contains a description of each part number. I would like to create a form where I enter the date, part number and quantity. However, once the part number is entered, I would like to displace some of the data contained in the query describing the piece.

Please note: Part numbers can be entered multiple times but each description contained in the query is unique.

Thanks for the help,

Greg

 

[PHV]

Have a look here:

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886