Viewing a value in a table

[Effie]

I am using a combo box in a table and am using two coloumns in the combo box.
I wanted both values to show in the table when I selected it from the drop
down list. I got both values to appear in a form the way I wanted but when
it comes to the table the second cloumn's value will not display making it
difficult for me to create a report or query using this value. Is there any
way that I can get that value to appear in a table or to create a report
using a form?

 

[Jeff Boyce]

If your database is well-normalized, you wouldn't want/need to have "both
columns" in your table. The way you get the "looked-up" value to show in a
form or report is to use a query that joins your table to the lookup table,
and returns the looked up value.