AnsweredAssumed Answered


Question asked by malijames on Apr 26, 2013
Latest reply on Apr 26, 2013 by malijames




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