Vessel Day to Day Database Questions

[DOHillier]

Good day,



I'm attemping to create a database for a small fleet of vessels (around 40 or so). The idea is that a person could make entries into the database based on the actions of that vessel, which typically call in at 8 AM and 8 PM everyday. There would be fields for position, commanding officer, current work order underway, operational status, commanding officer, etc.

I have created a relationship with a list of ship names and the table based on the primary key of each table. The relationship links a numerical value to each ship name. THe problem is that I'd like to automatically fill the name of the vessel in the correct field of the form that I've created from the table. SO far however, I've only seen numbers in those fields. So if value 1 is Ship 'A' then it should show the name of that ship. Currently it's only showing the numerical value (in this case, the number '1').

Any idea what I'm doing wrong here?

Thanks
D

Dale Hillier

[ranman256]

in a combo box, use a query that gets both ID, and Name.
bound col = 1
set the columns = 2
set col widths = 0;2

this way the combo will SHOW the name, yet the box stores the keyID.