AnsweredAssumed Answered

how to make viewa

Question asked by hamidriasat on Feb 6, 2017

I am trying to make something like this in File maker Database views.

The database will contain employees and projects. There need to be two combined views. One displaying the list of employees and which projects they are on in which week and by which percentage. The other one displaying the list of projects and which employees are on it in which week by which percentage. For each employee and each project there need to be a sum of percentages for all assigned projects / employees. I have made three tables in my database:

  1. employee
  2. projects
  3. employee_on_projects

Now I want to create these views. Can anybody tell me how to do this from scratch?

Thanks in advance.