0 Replies Latest reply on Feb 6, 2017 9:29 AM by hamidriasat

    how to make viewa

    hamidriasat

      I am trying to make something like this in File maker  https://i.stack.imgur.com/h9bp6.jpg2.PNG 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.