Combo Box will not save designated bound column data to the table

The Combo Box will not save the 'designated bound column' data to the table.
Using MS Access 2003 I've created a simplified example of the problem.

1 Reference table has been created to be used with a combo box

Table name: ref_Members

Field1/Col1=MemberID
Field2/Col2=MemberName

1 Input table has been created to accept data entry

Table name: Band Assignments

Field1/Column1=RecordNumber-(autonumber)
Field2/Column2=Instrument-(combo box-values I typed in- Col1 and Col2)
Field3/Column3=AssignedMember-(combo box-values from the Reference table Col1 and Col2)

In the case of both combo boxes, created by the lookup wizard tool in table design view,:
The number of columns in the combo box is 2
The designated bound column in the combo box is #2

In the dropdown lists both columns are shown
For example, if I update the information in the Band Assignments table:


Even binding the tables to a form didn't fix the problem.

Why is this not working properly? Any ideas? I vaguely recall some troubleshooting done back in 2008 but I guess I didn't note it in the forum and I could't find any posts that addressed this problem.

So,Here is the sample:

1. You should NOT be using lookups at table level. See here for why.

2. You should ONLY be storing the ID of the person/item instead of the name. You use a query to pull the name and ID together when you need them (like for a report).

It seems then that the lookup wizard in the table design mode is useless, a deception.

How will I be able to create the combo boxes that I need for the project. Could you offer any guidance using the example provided? I think I have designer's block

What you will have to do is create new tables to hold the data that is currently in the Table Level Lookups, and refer to these in your combo, and store the RecordID in the field that currently hold the lookups. Have a look at the attached sample for a practical example.