I know that, using the combo box wizard you can create drop-down lists which have more than one columns.
I have a combo box field in table1.
While creating it, I had run the wizard and made it get its values from a table (e.g.table2) which had a single column only.
Now, I've modified the table2 so that it has 2 columns.
I'm not able to make the combo box display both these columns in the drop-down list.
What I've tried so far (unsuccessfully though!):
In the design view of table1, under lookup in field properties > Row source > ellipsis button
Show > I ticked both the columns
But still, only column 1 shows up in the drop-down list
Is it possible to do this?