Hello
I am fairly new to access, and have a problem that I cannot figure out.
I have a table called scrapped, in this the following fields are present
Name - Date - Department - category - Part number - Price - Vendor ID - Vendor name - COPQ - etc....
What I would like to do, is to have another table (Price information) where I have part numbers, prices, vendor ID and Vendor name typed in. Then when a part number is entered into the first table (scrapped) the information for price, vendor ID and vendor is automatically pulled from the table (price information). Is this possible?
Best regards,
André