Return to FileMaker.com
Many to Many
I have Several Projects that are being worked on by 1 full time and several part time employees.
Each Full time employee is evaluated according to project they are working on.
Each full time employee must evaluate all part time employees working on their project.
Full time employees are also evaluated based on the informativeness of their part time employee evaluations.
I need to sort evaluations by project but also by employee to calculate their yearly reviews. How can I do both?
employees (ID, name, FT/PT)
project staffing (EmpID, ProjID)
projects (ID, Details)
evaluations (project, evaluator, evaluatee)
Retrieving data ...