AnsweredAssumed Answered

Query a table to produce a total based on number of records and show the results in a field of...

Question asked by kpmoy on Oct 24, 2011
Latest reply on Oct 26, 2011 by philmodjunk

Title

Query a table to produce a total based on number of records and show the results in a field of another table

Post

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

etc.

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?

Thanks!

 

 

 

 

Outcomes