4 Replies Latest reply on Apr 3, 2011 10:22 AM by krancmm_1

    Value List Default

    dg3321

      Title

      Value List Default

      Post

      Is there a way to set a value list so that one of the options in said value list is the default, and automatically appears when in browse mode?  Then the user could change the default to another item in the value list if need be.

        • 1. Re: Value List Default
          ryan

          Not exactly sure what your situation is, but you can set the field to Auto Enter the desired value from the value list.

          Then the default value will appear in all new records created.  Users can change the value upon browsing.

          • 2. Re: Value List Default
            dg3321

            that worked perfectly, thank you!

            • 3. Re: Value List Default
              fredmckinnon

              Hey Gang,

              This thread is nearly a year old, but it's exactly what I need to do ... I'm in FM 11 .. and I can't figure out how to do this:

              "you can set the field to Auto Enter the desired value from the value list"

              Field Name:  Return Status
              Type:  Text

              The field is set to display data in drop down list with values from:  Return Status Value List.  (No, Yes, Complete)

              I want the default to always be "No", unless changed - but I cannot find where to set this up to automatically choose "no".

              In my field options, under "Validation" I have it set to include a "Member of value list:  Return Status".

              However, I don't see anywhere in the value-list setup to define a default?

              • 4. Re: Value List Default
                krancmm_1

                You set the actual table field to the default value, not the value list itself.

                In Manage Database | YourTable | YourTable::ReturnStatus, click on Options for the ReturnStatus field.

                On the Auto-Enter Tab, the 5th selection down is Data.  Click on Data and enter No.  That will always show No as the default entry in the ReturnStatus field on your layout(s).

                Of course, double check that "Allow User to Override During Data Entry" is checked on the Validation Tab for ReturnStatus.

                HTH.