relating fields

[Tried of asking]

I have: Name field, affiliation field, department visited field, I want to be
able to choose the name from the drop down menu after it has been entered
into the database and the other two fields to be field in without having to
choose from the drop down. This would save 2 steps since the name,
affiliation and department never changes. The other fields do. How do I do
this? I can't look it up because I am not sure what it is called and I did
not create the form. Please help.

 

[orange]

I have: Name field, affiliation field, department visited field, I want to be
able to choose the name from the drop down menu after it has been entered
into the database and the other two fields to be field in without having to
choose from the drop down. This would save 2 steps since the name,
affiliation and department never changes. The other fields do. How do I do
this? I can't look it up because I am not sure what it is called and I did
not create the form. Please help.

On the Form, the drop down menu is called a ComboBox.
The concept of having Fields filled in based on a selection in a combobox is called a Lookup Table.

There are interesting articles about this at
http://www.fontstuff.com/access/acctut10.htm and
http://www.datapigtechnologies.com/flashfiles/combobox1.html (video tutorial)

 

[KARL DEWEY]

Your approach is wrong. Name field, affiliation field, etc for employees to
be in one table and only once but with an ID field that is unique such as an
Autonumber.

Them to display that information in association with other tables
(department visited) just join in the query on the ID. The combo uses the ID
as bound column but not display it but show name. Other text boxes using the
fields from the employee table to show other employee information as desired.

If further details is needed then post your table structure.