Query a table to produce a total based on number of records and show the results in a field of another table
I have several tables for our department.
Table 1: Names of Faculty in our Department
Table 2: Published Documents by our Faculty (usually more than 1 faculty member per document)
Table 3: Awards Received by Faculty
I'm new to Filemaker Pro so I may not have the correct terminology. Is there a way to put a field in the Faculty Layout that says "Documents Published in 2010" that will query the documents in Table 2 (that show the faculty member as being one of the authors) and return a quantity in that field?
Would this be the correct way to set up a database for what I'm trying to do?