Datasheet view problem

[TheB]

I have a table where one of the fields is defined a 'Long Integer'. The display control is 'Combo Box'. I am storing in this field a primary key from another table yet I am displaying a more descriptive field in the combo box. When I go into datasheet view for the table it seems to be storing the descriptive field in the table rather than the primary key field. Why would this be. All my other table fields that are defined the same way appear to show the correct primary key field they use.

Your help would be gratefully appreciated. I am new to Access and I am learning all the quirks it seems to have.

Thanks in advance.

...The B

 

[Jack Cowley]

If your combo is at the table level then you will see the description and not the PK. Remove the Combo box from the Lookup tab in the table and add your combo box on the form. Now when you look at the table you should see the PK. Be sure the bound column is set correctly as well.

I hope I correctly understood what it is you are doing.

Jack