1 Reply Latest reply on Sep 27, 2010 10:58 AM by philmodjunk

    Create value list from the values in 2 different fields for use in a 3rd field

    MikeDavis9536

      Title

      Create value list from the values in 2 different fields for use in a 3rd field

      Post

      I have a simple table that has field 1 with text and field 2 with text in it and I would like to be able to create a drop down list on field 3 that consist of the values of the text in field 1 and field 2.  Is this possible?

        • 1. Re: Create value list from the values in 2 different fields for use in a 3rd field
          philmodjunk

          It's not only possible, there is more than one approach depending on what you want to see in your value list.

          If you want a list of values like this:

          Field1value
          Field2value
          Field2value
          Field1value
          (and so forth with values sorted in ascending order)

          Define a calculation field in the table cCombinedValues as: List ( Field1 ; Field2 ) and specify cCombinedValues as your source of values for the value list.

          If you want a list of values like this:

          Field1value  Field2value
          Field1value  Field2value

          You can define a calculation such as Field1 & "  " & Field2 to use as the source of values or you might simply specify field1 as the column 1 value and Field2 as the column 2 value for a 2 column value list.