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 menues) one of the lists 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.

macster

[jeffer]

It seems that you want to see data in the 2nd value list that only corresponds with the chosen data in the first value list? The best way to do this is by a relationship. Create a new file with a relation id (like the class id) and an extra field for the class name. Create a relationship from the file with the two menu's and relate it from the fields of the first menu to the relation id in the new file. Go to the field properties of the second menu en edit the current value list. Select use values from field and select the relationship. When data is selected in the first menu, the second menu will only show data that relates to that choice:)

I hope that it's clear...my English isn't that good:(

greetz,

Jeff