How do I make a drop down menu that changes text fields contents after choosing a menu field?
I have an idea that I try to make in my database but cannot get it to work. I am still a beginner in Filemaker 9 and did study video tutorials to understand things better. Here is what I try to make:
I need a drop down menu that contains 10 choices to choose from. Next to this I have 10 times 12 text boxes in which I already have my text ready to be used. So every drop down menu choice is connected to 12 text boxes with predefined text description. Lastly, I need to have 12 empty text boxes in which those 12 text descriptions need to appear after making a choice from the drop down menu. Now what I want is whenever I choose one of the 10 choices from my drop down menu, the text in all 12 empty text boxes needs to change. Is it possible to make something like this in Filemaker and how do I do this?
I studied and tried out the fields, tables and relationships in Filemaker 9, because I think it has to be done with this, but I cannot get it to work. Can someone give me some good advice?