HI can anyone help, I'm trying to create a pop-uplist based on a field full of words seperated via a space, looks a little like

brown cow field milk calf (you get it!)

I'm doing a string count into another field called key1 (leftwords(keyword,1) and another in to a field called key2 (leftwords(keyword,2) then defining a value list which allows me to specify from key1 and also include key2 but thats as far as it allows me to go

in the html file im using valuelistitems

[FMP-if:currentdatabse.eq.picture.fp5]

<select name="keywords" size=1>

[FMP-valuelist:keywords, list=keywords]

<option>[FMP-valuelistitem]

[/FMP-valuelist]

[/FMP-if]

to create a pop-down menu in the browser, so anyway does anybody know a quick and simple way of counting all the words in the first keyword field so I can create a value list with them all in?

hope this makes some sort of sense to you guys - again any help would be appreciated

rgs

FileMaker Version: 6

Platform: Mac OS X Jaguar

Hi, rgs Binka! Hmm... admittedly, this is not my field of expertise (pun!), but I have not heard of anyone creating a valuelist from single field separated by spaces, but you can have a valuelist based on a field separated by RETURNs if the field is allowed to store repeating values.

brown

cow

field

milk

calf

udder

--ST

A quick way is to make a calculation using the Substitute function to replace the spaces in the field with returns, . e.g.

c.key1 defined as: Substitute(key1, " ", "

Thank you, thank you, thank you, it worked a F****** treat you super stars you!!!