Pretty simple formual question
So I think what I want is pretty simple. I have to two fields, one is a vendor name, the other is a vendor ID number. What I want to happen is everytime I select a specific vendor name, the vendor ID field is automatically filled in with the proper ID number. So for instance, if the vendor was CDW and the vendor number was 051, when I select CDW in the vendor name drop down list, 051 will automatically be filled in, in the vendor ID number field.
Any help is appreciated.