2 Replies Latest reply on Sep 22, 2012 7:39 AM by skwent

    Value list problem



      Value list problem


           I set up a value list for a drop down menu of contact names, for a field in a layout based on table "Jobs". The table with the contacts is labeled "Contact"

           It was working great, displaying both the ID# and Contact's Full name. Then I decided to see how it would work as an edit box instead of a drop down. I just toggled to edit list, didn't't like it, and toggled back to drop down menu. Now, despite asking it to display values from both fields, it only displays the ID#.

           The drop down menu, itself, has both the ID# and contact name, but when I make a selection, only the ID# populates the field. It is the correct ID and all other data relating to that ID# is correct as well, but I need to have the contact name displayed in this field. 

           What am I missing?


        • 1. Re: Value list problem

               I would guess that you used the inspector to specify "pop up menu" the first time around and set it to "drop down list" after trying it as an edit box.

               Pop up menus will continue to display the secondary field value after you exit the field drop down lists will not.

               You can, however, put a copy of the ContactFullName field on top of your drop down list if you give it an opaque fill color and use behavior settings in the inspector to prevent access to the field when in browse mode. This assumes that you have a relationship based on __pkContactID.

               With this setup, when you click on the ContactFullName field, the drop down list hiddent behind it will pop to the front and display your value list. When you select a value, it disappears back behind the full name field which now displays the name associated with the ID number entered into the field.

          • 2. Re: Value list problem

                 I can't believe that is all it was!

                 This problem has plagued me on a couple of jobs. I went back to check, and sure enough, and that was the issue with each. Thanks for enlightening me!