I am building an inventory tracking database. I have a table with the columns "Part#"(primary key), "Vendor" and "Notes". I want to have various forms that will draw this information. I want a user to open the appropriate form and select "Part #" from a drop down list, then have "Vendor" and "notes" autofill.
There will also be specific fields to each form, but this base info is what I am having trouble with.