Combo Box Question

[mkincanon]

Hi all, I'm sure this has been asked before, so I apologize in advance if this is a duplicate. Is there any way to to have the actual names that I have displayed in the combo box show up in the table rather than the ID Key?

[pbaldy]

That's the purpose of the ID field (to be stored in related tables). If you don't want to use it as designed, drop it from your table and just use the text field.

[mkincanon]

Okay... well, maybe there is another way to get to my goal. Essentially, I'm creating a database for employees to fill out when they finish their investigations. I was hoping for a drop down so that when they enter in the information, they are limited to filling out the data in a certain way with only a handful of options to choose from. However, when we look at the page that lists all of the closed cases (which is a table) it would be helpful to read the text instead of seeing a bunch of numbers. Access isn't widely used in our company and our senior management wouldn't really see the usefulness of just seeing numbers. Is there any other option to accomplish this?

[pbaldy]

Most of us never let users directly in a table or query. In a report, you'd base the report on a query that joined the two tables together, enabling you to return the text value from the lookup table as a field.

[orange]

Have you considered using a query, and joining the related tables, such that all info is available from the query. Just select the fields you want. You can use the query as record source for your form or report.

Here's a youtube link, and there are many others.

[pbaldy]

I'll get out of the way.