AnsweredAssumed Answered

Create a calculation field based on data pulled from another table

Question asked by jeng on Dec 22, 2016
Latest reply on Dec 22, 2016 by philmodjunk

Hello, all.


I'm fairly new to Filemaker and need to create a field that calculates the deposit amount for an individual student based on net tuition amount charged to that individual student for the previous year.  The calculated deposit field will be in the student's current year table and will pull from the student tuition history table.  The two tables are related by student ID and by academic year.  I'm not sure how to do this or if can even work as a calculated field.  Perhaps I need to write a script to do the calculation and then populate the field?  Thoughts?