Skip to main content
Question

Many to Many team assignments

  • April 27, 2017
  • 0 replies
  • 41 views
Hi, I'm stuck with this and hoping someone has a solution. I have a many-to-many relationship set up with three tables: Projects, Employees, Proj&Empl. I'm using the P&E table to form the many-to-many relationship between the other two. Each Employee record has a field for "Team", and there are four possible options for "Team" (let's say A,B,C,D for simplicity). Each Project has one Employee from all four teams. I have already created a report that shows me all four Employees assigned to each Project. What I want is to have a field in the Projects table that shows me "Team A Employee Assigned", so that I can use it in reports. Is this possible?
      This topic has been closed for replies.

      • EricJHansen
      • Registered
      • April 27, 2017
      In the projects to P&E relationship, count the number of P&E records where team is equal to A.

      From there, you can create a formula checkbox on the Project table with the formula:
      if([# of P&E Team A Assigned]>0,true,false)

      Let me know if that helps.
      Terms & ConditionsAccessibility statement