Hi

I'm trying to create a text result from a simple value list.

What it should do is when something is selected from the value list,

then anywhere on a layout -a text result should show which is equal

to the value list selected.

Example:

Value list = Apple, Banana, Peach

If "Apple" is selected from the value list then the result could be

a green "*" text, if "banana" then a yellow "*" and if Peach then

a orange "*"

Thats it.

Any comments will be appreciated.

Hi All,

I am having the same problem, I'm new to Filemaker (only know the basics) I am trying to create a database, with two fields one which you enter a number 1-10 and when a number is entered filemaker should eneter a name into the other field.

Example:

Number: 1 (entered)

Name: Jog Bloggs (displayed)

Any help would be great )

Thanks all

if value list is based on numbers:

second field formula:

choose(firstfielfd;"",name1,name2,name3 ....)

if you use colors:

make a repeating field which contains your colors (or colored text "*")

Case(firstfield="banana";getRepetition(repeatfield;1);

irstfield="apple";getRepetition(repeatfield;2); [....]

"")

You could also build value list on related files andalso show the second value in the list.

field2=listfile::description

Thanks! i got it to work!

Appreciated.