ID's in tables instead of values (1 Viewer)

D

David Ball

Registered User.

Local time

Today, 10:24

Joined

Aug 9, 2010

Messages

230

• Oct 7, 2018

• #1

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

Wino Moderator

Staff member

Local time

Yesterday, 17:54

Joined

Aug 30, 2003

Messages

36,125

• Oct 7, 2018

• #2

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

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Yesterday, 20:54

Joined

Feb 19, 2002

Messages

43,258

• Oct 7, 2018

• #3

What you are describing is normal and correct. A query that joins the ID to the lookup table as Paul suggested is the correct solution for any situation where you con't want to use a combo on a form/report.