troubleshooting Question

How to show multiple fields from a linked table on a form

Avatar of Kevin
KevinFlag for United States of America asked on
Microsoft Access
15 Comments1 Solution80 ViewsLast Modified:
I have a form that displays Company information.  There are fields in this form (and the table that it is based on) for

Primary Industry,
Secondary Industry, and
Main Customers Industries.

The values for these fields are picked from a list from another table named NAICS codes, that has a code number in one field AND a description in another field.  When selecting either a Company's Primary Industry or Secondary Industry on the form, the pull down list looks great:

Linked table od codes and descriptions
but once the industry is selected from the list, the resulting entry on the form only displays the code field and not also the description field:

Form display of selected industry
QUESTION 1: Is there a way for me to adjust the form so that the user will still get the dropdown list of codes and descriptions, but change the resulting display so that BOTH the code and description show on the form?

Similarly the form box that shows the industries of the companies customers picks from the same list, but MULTIPLE selections are allowed:

listbox allowing multiple selections
And after companies are selected, the form just shows a CSV of the codes with no descriptions:
list of the industries of the company's customers
QUESTION 2: Can I have these results in a list that show all codes and descriptions instead of a csv list of just the codes on 1 line?

(If this is too complicated for me to do (even with EE assistance), an alternate that might be acceptable would be for the selections in the form to be the DESCRIPTION field from the related table instead of the NAICS code.)

Thanks very much for the help,
Kevin
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 15 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 15 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004