Listbox to Show Table Data

[jmenzer]

I am trying to use a Listbox to show the contents of Table, called Table1. Now Table1 has 6 columns 2 of which lookup information from Table2. When I use a listbox to view Table1, I see all 6 columns, but the 2 columns that lookup information in Table2 show only "ID" numbers instead of the information I want to see.

So Basically in the listbox in the "Contact" Column I see the number "5" instead of "Joe Smith". When I view Table1 I see "Joe Smith". When I view Table1 through a listbox I see "5". Anyway to correct that.

Thanks

Joe