Combobox to display result in a text field

[weilerdo]

Hi All, I hope someone can help with this, I have 2 tables, 1 main table that holds all my part data ( ie part num, description, etc) and a second table with vendor info. On my Form I have all my fields that display the record. I placed a combo box on my form that I need the user to be able to select a vendor, which is working but I need the form to show the vendors part number in a field. The main table has a manufactures part number, and I have 3 fields that have my 3 vendors part numbers for that part in it. I have the combo box so that it shows the vendor name but how do I get it to look at a certain field for the vendor part number. Im still really new to Access and am clueless any help would be greatly appreciated. I know I have not explained this every well so I am attaching a sample of the DB so you can see that I have Thanks again

Thanks everyone..

 

[le888]

Not quit understand what you want. Can you put in red the field with problem in your database. Give me an example what you want to do, I can find the vendor part number (in which table).

Le

 

[weilerdo]

Hey le888 thanks they I did not think I was explaining it right. Right now in my tbl_master I have a field called part_num with is the manufactures part number. I also put 3 fields in that table Grainger, Home Depot, McMaster which hold the vendors part number for that manufactures part number. Not sure if thats the right place for those 3 fields or not. On my form, down at the bottom in the middle is a section called "Ordering Info". What I need is for the user to be able to select from the combo box which vendor they want to get the part from ( IE Grainger, Home Depot, McMaster ). which is working but in the same section there is a field on the form called "Vendor Item Number" which I need to have populate with the correct vendor part number. That is where I am totally lost. Im not sure if I need a seperate table that will have the 3 fields for the vendor part numbers or how I can have it pull the vendor part number that is associated with the correct manufactures part number. I hope that explains it a little better. Any help would be so appreciated on this one. thanks again.

 

[weilerdo]

Here is a visual, if it helps

 

[le888]

See if this what you want...

If you click on "Grainger" than the part number is "2W199" which corresponds to "Item 123", etc.

Le