AnsweredAssumed Answered

Using a drop down menu to add values to a field

Question asked by MaxwellRobin on Dec 30, 2012
Latest reply on Dec 31, 2012 by philmodjunk

Title

Using a drop down menu to add values to a field

Post

      

     Hi All!

     So I have a field with a drop down menu.

     The menu gets its value list from a field in another table.

     When I click a value it populates the field as it should.

     If i click a new value it repopulates the field with the new value.

     What i would like it to do is add the new value to what is already populated.

     Also, i wuld like filemaker to recognize if the numbers are in sequence or not.

     for example:

      

     The user clicks the number "1" from the drop down menu.

     What the field should look like is this "1"

     The user then clicks the number "2" from the drop down menu.

     What the field should look like is this "1-2"

     The user then clicks the number "3"

     What the field should look like is this "1-3"

      

     The user then clicks the number "5"

     What the field should look like is this "1-3, 5"

      

     The user then clicks the number "6"

     What the field should look like is this "1-3, 5-6"

      

     The user then clicks the number "7"

     What the field should look like is this "1-3, 5-7"

     And so on.

      

     The user should also be able to click values out of numerical order and filemaker will order then in numeral sequence like what was stated above.

      

     Is this possible?

     If so some help would be greatly appreciated.

      

     Thank you!

Outcomes