6 Replies Latest reply on Mar 9, 2010 4:30 PM by 3WaveGuy

    Return both fields from value list

    3WaveGuy

      Title

      Return both fields from value list

      Post

      Is there somewhere I can set the value list to return both fields that are displayed?

        • 1. Re: Return both fields from value list
          JoshO.

          You can do it...you just need the right relationships.

           

          For example, if you are showing unique id and a name, the value will set the one field.  Then you can place another field to display the name from that related table.

           

          If you are talking about pulling in 2 fields without using a unique identifier...then it is a little trickier and you will need to provide some more detail about your setup and what you are trying to do.

          • 2. Re: Return both fields from value list
            3WaveGuy

            Hi Josh,

             

            I am not sure what you are saying.

            I have a value list that displays two fields:

            Doctor Name and Doctor ID.

            When I select from the value list it shows only Doctor Name in the field. The Doctor ID does not show.

            • 3. Re: Return both fields from value list
              philmodjunk

              Add a second field from the related table next to the first to supply the missing information.

              • 4. Re: Return both fields from value list
                3WaveGuy

                Thank you for answering my request.

                 

                In Manage Value Lists; Edit Value List; Specify Field; 

                    It asks to use values from First Field (Doctor Name), then there is a radio button to display a Second Field (Doctor ID), which I also check.

                 

                Entering the field in Browse Mode, activates the drop down which displays both fields. When selected the first field only is assigned. Is there an option to assign both fields?

                 

                Your statement "Add a second field from the related table"  begs 2 questions:

                  1. What related table? I don't think I have one.

                  2. Where do I add it (in the manage Value List Dialogue; or in the layout)?

                 

                Do you mean:

                  On the Value List, Have the ID as the first field.

                  Relate the table to the Doctor file on ID

                  Then place a field on the Layout from the Doctor file called Doctor Name

                • 5. Re: Return both fields from value list
                  comment_1

                  I believe it needs to be the other way round: make Doctor ID the first field in the value list definition, and Name the second one.

                   

                   


                  3WAVEGUY wrote:

                  What related table? I don't think I have one.


                   

                  Then what is this for?

                   


                  • 6. Re: Return both fields from value list
                    3WaveGuy

                    It works!

                    Thanks All.