gumstic Posted April 16, 2003 Share Posted April 16, 2003 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. Link to comment Share on other sites More sharing options...
bwill2000 Posted April 16, 2003 Share Posted April 16, 2003 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 Link to comment Share on other sites More sharing options...
cjaeger Posted April 16, 2003 Share Posted April 16, 2003 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 Link to comment Share on other sites More sharing options...
gumstic Posted April 18, 2003 Author Share Posted April 18, 2003 Thanks! i got it to work! Appreciated. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7844 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now