Selecting data in a dropdown box

[nateobot]

Hey all,

I have two tables.

Customer:
CustID
CustName
CustAddress
etc...
OwnerID

Owner:
OwnerID
OwnerName
OwnerPhone
etc...


On my main form I am trying to have a drop down box with the different owners to assign to a company. I would like them to search through the names, select one, and have that update the OwnerID field for the Company.

When I try doing this however it tries to either A. populate the name into the OwnerID field or B. populate the OwnerID into the OwnerName field.

If anyone needs further info please ask.

Thanks
-Nate