Combo box on form displays primary key not data

[Alriemer]

I have created a lookup 1-to-many relationship to let a user select one of several values for a certain field. (The table contains information about classical music composers and the field is a list of eras - classical, romantic etc.)

When I edit the table directly, in datasheet view, the relationship is represented by a combo box with a menu of the eras (there are about 10 of them, listed in a separate table).

However, in the form which I am building to update the table, the combo box for the same field only displays the primary key, which is a meaningless auto number. How can I get the combo to display the actual options (column 2 vs. the autonumber in col 1)?

Thanks
alriemer

 

[Dugantrain]

In the Combo Box's Properties:
-Format->Column Count->Type in 2
-Column Widths->0'';1.5''
or however wide you'd like your visible column; the important thing is that the first column's width is set to 0.