Microsoft Access: How do I create a drop down list that stores the index value, but displays text va

[FlyingMonkey]

For example:

I have my primary table called Projects with headers as follows:

Projects ID, Project Name, Project Leader ID

And I have a second table called Project Leaders which stores Project
Leader ID as the primary key with headers as follows:

Project Leader ID, Project Leader Name

I am trying to create a Project Entry Form that displays and has a
drop down of the Project Leader Names, but stores the Project Leader
ID in the Projects Table.

Thanks for your help!

 

[tina]

in your form, use a combo box control. set the RowSource to the Project
Leaders table. number of columns, 2. column widths, first column 0", second
column however wide you want it to be (ex. 0"; 1.5"). bound column, 1. limit
to list, Yes.

hth

 

[FlyingMonkey]

in your form, use a combo box control. set the RowSource to the Project
Leaders table. number of columns, 2. column widths, first column 0", second
column however wide you want it to be (ex. 0"; 1.5"). bound column, 1. limit
to list, Yes.

hth












- Show quoted text -

Ahh, thanks! i was about to write a bunch of vba code to do it on the
after update event. =P

 

[tina]

you're welcome

Ahh, thanks! i was about to write a bunch of vba code to do it on the
after update event. =P