2 Replies Latest reply on Apr 26, 2013 3:33 PM by malijames

    lookup

    malijames

      Title

      lookup

      Post

      I'm totally new to filemaker I'm trying to create student database . So I created two tables 1. Studenttable.  Field are id, name, class,fee 2. Classtable. Fields are classname , fee Now I would like if I type in a class name in class field on studenttable , the fee in studenttable  will automatically populate with the value from classtable fee which corresponds to the classname. And if I change the classname, fee should also change.  I tried to read lookup,relookup but could not understand it and also try to use script trigger but I don't know how to use it. I can perfectly do this in ms access using Dlookup But I would like to migrate to filemaker. Pls direct me on what to do Thanks in advance Using FM pro v12 window 7

        • 1. Re: lookup
          philmodjunk

               And how many classes can a student take?

               Your two table design supports students taking only one class. If they sign up for multiple classes, you need another table in your system.

               Working with the one student, one class set up implied by your current design, you'd need this relationship:

               Student>------Class

               Student::_fkClassID = Class::__pkClassID

               For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained

               With such a relationship, you can define a value list where __pkClassID is the first (primary) field and ClassName is the secondary field. This allows you to select a class by name, but the value list will enter the class ID number. then a fee field in Student can be set to lookup the fee field in Class.

               But I suspect you'll need that third table so that a student can enroll in multiple classes. The above concepts still apply, but two that new "registration" table rather than to Student.

                

          • 2. Re: lookup
            malijames
             sorry for the late reply I was carefully following and understanding your instructions. it's working just like you said and students can only register one class at a time. Class refers to  level or grade here Thanks a lot