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?