2 Replies Latest reply on Jan 5, 2011 4:44 PM by ThomasBates

    Filemaker Pro Newb:  Drop Down Lists help!

    ThomasBates

      Title

      Filemaker Pro Newb:  Drop Down Lists help!

      Post

      I'm a newb to Filemaker Pro, but mildly familiar with Oracle DB's, so it's not super-new.  

      I'm doing the 30 day trial, and working on an application for my wife to track student development.

      So I have two tables, Students and teachers.  

      The students table has:

      StudentID

      TeacherID

      Name

      ..etc.etc.etc.

      The Teachers table has:

      TeacherID

      TeacherName

      etc.etc.

      So I want to be able to use a drop-down list of the teachers in the Students layout so you can edit the teacher assigned to the student.

      It's getting it work is the problem!  I've tried to many ways, and it doesn't seem to work; I've setup the relationship between the tables, but can't do the entry correctly.

      Can someone talk me through the steps it should be in the Inspector? 

      Thanks!

        • 1. Re: Filemaker Pro Newb:  Drop Down Lists help!
          philmodjunk

          Open manage | Value lists and click the button to create a new value list.

          Enter a name for your value list and select the "Use Values from Field" option.

          Select Teachers from the drop down of table Occurrences at the top, then click TeacherID to highlight this field. In the second drop down, you can select TeacherName so that the value list has two columns of values, the ID number in column 1 and the name in column 2. This value list will list all teacher names and IDs from your teachers table. If you select a value from this list, the ID number will be entered. If you enforce unique teacher names, you can even hide the first column of ID number from view.

          Click OK until you've exited the Manage dialogs.

          In layout mode select your TeacherID field on the students layout and use the inspector to change the field from and Edit Box to either a drop down list or pop up menu and select the name of your value list in the drop down. (You can use the pencil button here to create or change value lists as it pops open Manage | Value Lists for you.)

          • 2. Re: Filemaker Pro Newb:  Drop Down Lists help!
            ThomasBates

            That worked! Thanks much!