info in field separated by colon, drop down menu

[outdoorsportz]

We have a record, in the record is a field that has info separated by colons, Ex: blue:green:black we want to make a pull down menu with this information. We can't figure out on how to make filemaker recognize the ( in the field, so that the pull down menu sees each bit of information as separate info. We know how to enter the info to make a pull down menu, but not how to make it recognize what is in the field. Thanks

[john.daly]

There might be an easier way but this script will do it:

You need to define global fields: gString [Text]; gCharacter [Text}; and gCount[Number]; and a text field New Value List.

Go to record/request/Page[First]

Loop

Set Field [gCount,1]

Set Field [gString,Value List]

Set Field [New Value List,""]

Loop

Set Field [gCharacter,Middle(gString,gCount,1)

If [gCharacter,"<carriage return symbol>"]

End If

Set Field[New Value List,New value List & gCharacter]

Exit Loop if [gCount = Length(gString)]

End Loop

Set Field [Value List, New Value List]

Go to record/Request/Page [Next,Exit after Last]

End Loop

Best of luck!