Select from Drop list and populate other field

[shonaart]

Hi
Please could you help me. Access 2007. Thanks for a great site.

1. I have created a two tables. Vessel Details , has all the details about the Vessel.
2. Second table " Prouction Table" is where I enter figures ( Productions of those Vessels in the Vessel table file. ) I made a relationship with two tables on Vessel Number ( Each Vessel gets a unique number )
First field I created a Drop down list ( Vessel Number ) so I can select the Vessel from the Vessel details

Question:
When I select the Vessel number I want the name as well to pull through from the Vessel Details , to my field call Vessel name. How do i get the name to come into the second field ( Vesel name to come through.

Thanks
Vaughan

 

[neileg]

You don't need to store the vessel name since you have the ID. If you are using a table level drop down this is bad news. Nobody can really understand why Microsoft added them since they cause all sorts of problems. You should be doing these actions in a form, not in the table. If you use a combo box as your drop down, you can include the vessel name and ID there. You would see both columns for selection, store the ID and display the name.