Bound column = 2
Column count = 1
Control source= name of the required
RowSource = SQL construct
RowSourceType = 3 (SQL Statement)
Style = 2 (dropdown list)
The problem is that the returned value should be the primary key associated with the selected field.
Instead it returns the number of what I selected
Example
Displayed Value
Name, Primary key
==============
Bob,25
Sam,32
Instead of returning 25 when I select Bob the value that goes in the table is 1.
What's wrong here?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé