I want to get a data info. from a table bouned by a drop down list.

Hi, Guys

I am expecting an answer like before. I have a drop down list data bounded to a data base called vendor. Then if a user selects one item from drop down list, then I want to get an info. from a field in the same data base. In the drop down list, the item is bouned with a field name 'vendor name'. But I want to retrieve an another datafield called 'vendor owner name' in that data base in the same row selected by vendor name. The actual situation is like this:

drop down list : bounded field name is vendor name. User selects a vendor name through drop down list. Then I want to get an info. about the vendor's owner name in the same row selected by vendor name. How can I get the data info? Please answer me. If any more detail thing, let me know. Thanks you guys ........

 
...