Hey there! I have had this problem so many times, and I am hoping to get to the bottom of it, because I bet there is something very simple to fix it.

I have a listbox on my form, it has 2 columns, [Item Name], and [Category], both from an "Inventory" table. The [Category] column in the Inventory table, however, is actually a lookup to a "Category" table...

Now in my listbox in the category column, instead of saying "Tools" or "Consumables" for example, it instead shows "5" or "8", which is the Category ID number.... How do I make it say the category name instead of the category ID? I'm sure you will need more info, but I'm not sure what. heeeelp!