I have just barely started using access, and am trying to add a location column into an inventory program in Access 2003.
I have a table for local location names, for example "Denver" or "Portland". this table is used as a pull down menu for choosing the location of a specific transaction in an inventory table. In my inventory Table, all locations are shown in text
However, when i go to insert this data into my sub-form, it only shows the primary key # of the corresponding city, and refuses to let me enter text into the field.
you have no idea how silly i feel asking this, but any ideas on what i need to do to get this field to show text?
I really appreciate anybody willing to help out a newbie on a simple question.
thanks