This can be done with a summary field and a filtered portal in FileMaker 11 and with a "filtering" relationship in older versions.
What version of FileMaker are you using?
What two tables are used in this layout (one for the layout and one for its portal) and how are they related?
EVALUATION table (table with the portal)
DBE table (table with the companies info)
EVAL_DBE (join table)
Using FM v9
To repeat: what two tables are used in this layout (one for the layout and one for its portal) and how are they related?
Yes one is for the layout (EVALUATOR) and the other is for the portal
I have used a primary key, a foriegn key and a join table
Does the portal refer to the join table, EVAL_DBE or the DBE table?