I have a form that displays Company information. There are fields in this form (and the table that it is based on) for
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:
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:
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:
And after companies are selected, the form just shows a CSV of the codes with no descriptions:
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,