ID's in tables instead of values

[David Ball]

Hi,

I have a form where the user can select values from Comboboxes and the values are stored in a table. The problem is that while the form displays the values I want to see the table only displays the ID’s. I want to create a report from the tables so the ID’s are worse than useless.
How can I display the values in the table rather than the ID’s so that I can create a meaningful report? I initially tried to use lookups in the table to overcome this problem but have been advised that this is bad practice.
Thanks very much

Dave

 

[pbaldy]

Sounds like what should happen. You base the report on a query that joins the tables together, enabling you to return the text field.