Populating drop-down based on database records

[scottchampion]

I need to display one value in a form drop down, but insert another
value when the user clicks submit.

I have created a form that inserts records into an Access database
table. Each record in the table requires an EmployeeID (among other
things). The problem is that users do not know employees by their
Employee ID. To resolve this problem, I need the form to display a
drop down menu containing employee names. When users submit data,
InfoPath needs to convert the name into an Employee ID then insert the
record into the table.

I assume that this is not only possible, but also elementary. Can
anyone point me in the correct direction to solve this problem? I
would like to make use of my Employee table which associates employee
names and employeeIDs.

Thanks!
Scott

 

[Ishai Sagi]

You are correct. it is simple.

When you go into the dropdown properties, you will find that when binding
the dropdown you have different boxes for "display" and for "value". You need
to configure the datasource to return for each row (each employee) both the
ID and the display name, and bind the dropdown to display the names, but
store the values.

 

[scottchampion]

You are correct. it is simple.

When you go into the dropdown properties, you will find that when binding
the dropdown you have different boxes for "display" and for "value". You need
to configure the datasource to return for each row (each employee) both the
ID and the display name, and bind the dropdown to display the names, but
store the values.

This worked perfectly. Thanks!