ComboBox results on form show as a number in report

[jackmac]

Hi all,

I have a form which has a ComboBox with supplier names. I created a table
just for the suppliers and the combo box is populated by this table. When I
try to run a report or query based on products, the supplier field doesn't
show names, only numbers! I'm guessing the numbers relate to item number
for the Supplier record in the table (is that right?) The difficulty I have
is that if I try to run a report based on a particular supplier it won't
work as it only sees numbers!

Anybody any idea how I can get the supplier nams to show and not numbers?

TIA

Jack

 

[John W. Vinson]

Hi all,

I have a form which has a ComboBox with supplier names. I created a table
just for the suppliers and the combo box is populated by this table. When I
try to run a report or query based on products, the supplier field doesn't
show names, only numbers! I'm guessing the numbers relate to item number
for the Supplier record in the table (is that right?) The difficulty I have
is that if I try to run a report based on a particular supplier it won't
work as it only sees numbers!

Anybody any idea how I can get the supplier nams to show and not numbers?

TIA

Jack

Base the Report on a Query joining your main table to the combo box's row
source. You are likely another victim of the Lookup Field misfeature, which
conceals the actual contents of your field behind a combo box; what's actually
stored in your table is a numeric ID, but what you SEE is a supplier name
looked up from another table.