G
Guest
I'm clearly missing something, and I want to believe I'm not the only new
user to have this problem, however, I couldn't find anything through keyword
search on the board. I'd appreciate your help.
In the Access class I took, I was taught that each table needed to have a
Primary Key, where the Primary Key was unique in each record. To obtain
this, it was suggested that the first field we create in a table is an ID_#
using Autonumber. So I have a table T States (ID# - auto; State - text;
StateAbbrv - text). In my form, I created a combo box using T States. On
the Form, for the properties of this box, I chose field 2 (State) as my bound
field, showing 1 column. However, when I do a dropdown window in the combo
box, all I see is the ID_#. I COULD remove the ID_# field ... but do I
really want to do that?
What am I missing?
Thank you. This board is great and the expertise here has helped me get
out of more then one jam.
user to have this problem, however, I couldn't find anything through keyword
search on the board. I'd appreciate your help.
In the Access class I took, I was taught that each table needed to have a
Primary Key, where the Primary Key was unique in each record. To obtain
this, it was suggested that the first field we create in a table is an ID_#
using Autonumber. So I have a table T States (ID# - auto; State - text;
StateAbbrv - text). In my form, I created a combo box using T States. On
the Form, for the properties of this box, I chose field 2 (State) as my bound
field, showing 1 column. However, when I do a dropdown window in the combo
box, all I see is the ID_#. I COULD remove the ID_# field ... but do I
really want to do that?
What am I missing?
Thank you. This board is great and the expertise here has helped me get
out of more then one jam.