AnsweredAssumed Answered

lookup

Question asked by malijames on Apr 26, 2013
Latest reply on Apr 26, 2013 by 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

Outcomes