need help pulling data from 3 tables
Posted on 2006-05-01
To give you some background with my requirement, i have an access database that works great. We issue purchase orders and receive equipment against the Purchase Orders. However we do not know what part numbers we will be receiving until the equipment arrives. Sometimes its 1 line item other times its 30 line items each with different qtys. I need the user to be able to pull up a PO#, cross ref a part# to a description, and fill in the QTY that has been received for that particular po#. I am trying to create a form that pulls data from 3 tables, and also captures new data from the user. The new form is called "Pre_Inventory" I need to pull information from 3 tables. The 1st table is "Puchases" from this table i need the field "PO_number" . The second table is "Part_Number_Ref" from this table I need the fields, "Part_Number" and "Description" The 3rd table is "Pre_Inventory" which has fields PO_Number, Part_Number, Description and Quantity. I need the 3rd table to collect the data from the Purchases and Part_Number_Ref, and at the same time the user needs to manually enter the QTY of each line item. The idea is that the PO_number doesn't have to be typed in for every line item, once the user types it in the 1st time, it auto-populates every next record that is used. Also once the user cross refs the Part_Number and Desciption, I need Part_Number and Desciption and po# all to appear on one record in my form. Please advise the best way to have a form that can accomplish this for me. thanks for your help!