Help with auto update of fields in form

[u0909098]

Hi, I am a newbie and have some questions would like to ask you guys.

Attached file is the relationship of some tables I deal with. My database requires adding/updating information of a ship, which i divided into 3 tables for better mgt. The Co_Code (company code) is the primary key for all 3 tables, but when users update, they want to use Christian Name (a field inside tab_shipList table) as a filter.

When I choose from the list of Christian Name, my expectation is that all the following fields for the ship will be automatically updated. But I dunt know which control I should use. I tried creating form from query of all ships' information, but dunt know how to do next.

Anyone can help me. Thanks

[NTC]

The combobox, or listbox, in the header of a single record view form (rather than continuous form) - - is the traditional method to do what you seek. When you drag onto the form design, the wizard will offer you a choice to 'Find record....'.

Hope this helps.