Selecting Values from a Value List

[macster]

Hi, I am new here to the list and well also new to filemaker pro. I am creating a database for my school and well up to now I have an ok question. I have two value list as (pop up menus) one of the list is a (1) class id number menu and the second list is the (2) class name menu. What I want to do is the following. When I select the class id number menu and select an id, I want the class name menu to set itself to the corresponding class name of the class id number. (e.i. I go to my class id number menu and select id 01.00. I want my class name menu to set itself to "mathematics" because that is the name for the id 01.00) hope someone can help me.

I also use REALbasic and well even though is a lot different than filemaker pro I can just tell my popup menus popupmenu1.listindex=popupmenu2.listindex <==this is the code that I need for filemaker pro. I know is not the same but if someone here knows realbasic then they will understand what I am talking about. Thanks in advance.

P.S. filemaker should make a index value for value list so we can select values with the index of the list like in REALbasic.

macster

[Anatoli]

I am not sure about your problem, but maybe this is it:

From FM help

If you are generating the values in a value list from a field, you can have FileMaker Pro dynamically change the value list's values based on the values in a second field. In other words, the value list will only display values in the first field from related records where the relationship definition is met by a value entered into the second field.

For example, imagine you have a database called Product that tracked a large number of inventory items. You could define a value list and assign it to the Product Name field to display only a subset of those items based on values in a second field, Category. During data entry, when you specify the value of the Category field (for example, Accessory), only the Product Name values where the Category equals Accessory show up in the value list. Similarly, if the value of Category changes to Clothing, the values for Product Name change to those records where Category matched Clothing.

In the above example, you would perform the following basic steps:

1 Define a value list for Product Name with the Use values from field and Only related values options.

2 Define a relationship to the same database file (a self-join) and specify Category as the match field. (See the help topic Defining relationships for relational databases and lookups)

3 Specify that the value list use values from the related field Product Name.

When you enter a value for Category, FileMaker Pro retrieves the related records where Category matches the value you entered, and displays the corresponding Product Name values in the value list.

Note Both the field with the value list values and the match field for the relationship must reside in the same file, for example, Category and Product Name from the example above.

Copyright

[macster]

Ok maybe I did not made myself clear. I have to pop up menus. (1) Popup menu number 1 has the following id values: 01.01,01.02,01.03,01.04... and so on. (2) Popup menu number 2 has the following class values: History,Algebra,Sciences,P.E....and so on. When I select the value 01.02 from popup menu 1 I would like for popup menu 2 to set itself to "Algebra" because that is the class with the id 01.02. Now instead of my coding to be: case(test,result,test,result,test,result...) and so on I thought their would be something easier. An easier way would be to select an id from popup menu 1 check to see what value index it is and set popup menu to the same index so all my id and classes will be coupled. Thanks in advance

[Vaughan]

It sounds like you need another file for the course codes and course names.

Use this a "table" to generate a value list for the codes also displaying the course name. Create a relationship to the course file, and use this to populate the course name field.