Lee Have you set the column width of your ID field to zero?

Lee That's how relational Combo Boxes work. You store the ID from the related table NOT the text.

Ugh, yeah, sorry, I should have read closer. Didn't notice "at the Item Table...".

Ok I understood that but I thought it would display the text. Okay so is there a way to create a lookup field that will display the text after I choose the option? If not I will just have to go back to using my manually entered values.

Typically, you don't want to use your table for entering and viewing the data in your database. Forms are for entering/editing data, and reports are for viewing the data when you've compiled what you need.

While it is discouraged, you can make a form with a relational combo box (like the one you used to enter the data) and set its default view to "datasheet". This will look just like your looking at the table directly, but it gives you a little more control over how it looks. However, it can also be just as dangerous since you could risk deleting columns, etc, by accident, just like on the table.

A better option is to create a continuous form with only the fields you need to work with which can also have the relational combo box.

Or again, if you are only "looking" at what's in the table, you can create a report that puts all the information you want to see together.