Winddancer

Yes, indeed this case scripting is working. Unfortunately I have far more than 500 possible results and you can imagine how many cases I have to script. I tried this however, but Filemaker only allows up to 30.000 characters per calculation. Is there any other way to store this x / y table? Best would be if I could add items to the x and/or y row/column. best regards Sven

Hi all, I have a problem. In my Filemaker document are three fields. Two value lists containing text. One field which shall display the result. e.g.: Value list one has jobs: "Designer, Programmer, Support". Value list two has tasks: "Repairing Computer, Creating HTML page, Helping Customer". Now when I enter my document I choose a job (value list 1) and a task (value list 2). The last field shall now display the time needed. Designer needs for: - HTML PAGE - 1 hour - REPAIRING COMPUTER - 3 hours - HELPING CUSTOMER - 2 hours Programmer needs for: - HTML PAGE - 2 hours - REPAIRING COMPUTER - 3 hours - HELPING CUSTOMERS - 1 hours So if I chose Designer as a job and Helping Customer as a task, my third field would display 2 hours. this is just an example. the easiest way to explain is: you draw yourself (on a piece of paper of cause) a table. x axis for jobs y axis for tasks And I need the result of the x - y match. I hope I made myself clear. My english isn't all too good sorry for that. Unfortunately I couldn't find this anywhere and I got to present this feature tomorrow. argh. So if you have any idea how to solve this: PLEASE LET ME KNOW! regards Sven Germany [ February 07, 2002, 03:18 PM: Message edited by: Winddancer ]

Hi all, this is my first visit to this forum and I haven't used Filemaker all too long. So I hope you bear with me while I am asking some "dumb" questions! I have a Filemaker document, which contains a list with several values (drop down) and 6 additional data fields (marked as number containing data fields). The problem is quite simple: How do I assign a list from the drop down value in a way that if I choose one value from the drop down menu, the 6 additional fields are filled with predefined values? Is that a dumb question? Well I think so. I also don't know if this is the right forum.... bear with me! kind regards Windey

wow sounds good. ill try it right away. Say is "(Field 2" the name? and ", 2)" the value what it should look like? Set Field(Field 2, 2) ah never mind i ll test it anyway! thx and kudos Windey