AnsweredAssumed Answered

Showing text from a second field in a value list

Question asked by GuyGrenier on Oct 13, 2014
Latest reply on Oct 13, 2014 by GuyGrenier

Title

Showing text from a second field in a value list

Post

I have two tables : NAMES and ACTIVITIES

NAMES contains the fields IdNumber and Name 

                                                                                                                                                                                                                                                                                         
IdNumberName
1Bob
2Martha
3Willis
4Imelda

ACTIVITIES contains a field Participants

The table NAMES serves to create a value list the is used by ACTIVITIES::Participants

The value List_of_names list is based on NAMES::IdNumber. In the properties of List_of_names, I selected the possibility to show the data from NAMES:Name (show values from a 2nd field)

In one layout, the field ACTIVITIES::Participants shows a check list where appears List_of_Names. So I can select a few of the names appearing.

                                                                                                                                                                                                                                   
 Bob
XMartha
 Willis
XImelda

 

I chose to build the value list through NAMES::IdNumbers because the precise text in the field NAMES::Name may be modified in the future. For example, if I want Bob to be Bob Smith instead, IdNumber 1 will be checked and Bob Smith will be chosen.

Here’s my problem:

In another layout I want a field that shows only the selected names. Since my value list is built from NAMES::IdNumber, if I use the field ACTIVITIES::Participants as an edit box, I get the following result:

                                                 
               

2

               

4

               

When in fact, I would like to get: 

                                                 
               

Martha

               

Imelda

               
 
               

What is the easiest way to achieve that?

Outcomes