Jean-Pierre,

If you are using VFP 5, then the new "BoundTo" property may also be useful here. Check it out in the Help.

Good Luck,
Jim N.
>>Hello,
>>
>>I want to allow the users to select a customer using a combobox.
>>The customers have an unique identification number, so I want to fill the combo with the customername and the number. If the user selects a customer the combobox returns the combo Row number, and NOT the customersid.
>>
>>This is a big problem as all my relations work with an identification number!!!
>>
>>Please help,
>>TIA
>>
>>Greeting,
>>Jean-Pierre
>
>
>Hi, Jean-Pierre,
>As you found out, Combo boxes see a number entry as a row number. Use the display value of the combo box which will carry the ID# shown on the screen (the value from your lookup table). It will be a character string, so you'll have to change it back to a number with the val() function.
>
>HTH
>Barbara