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?