>>I have a pick-up combo box (drop down list) and its RowSourceType property is 6-fields, RowSource is, say, "Items.ItemId,ItemDescription", so the dropdown list has two columns and the BoundColumn property is 1 (for ItemId).
>>I want to store the ItemId but I want the dropdown list to show only the ItemDescription column. Any solution to this?
>
>Reverse the rowsource and make boundcolumn property to 2. Columncount should be 0 and ColumnWidth to none.
>
Jess,
I tried what you adviced me, It worked very fine just what I needed, but there´s one more question: Since this drop-down list belongs to one of several child tables. I have to maintain it synchronized with the parent table as I navigate through the parent table, so, the table that is the recordSource for the drop-down list is SET ORDERed TO ItemdId, well, I would like to know a way in which when I drop down the list It appears ordered on ItemDescription.

Thanks
Luis A. Guerra Chávez