ContributionsMost RecentMost LikesSolutionsRe: Many to Many team assignmentsThanks, I used the first idea and made it work. One thing that was messing me up was how our tables were built - a lesson for the future.Re: Many to Many team assignmentsOops my original question wasn't clear. I need to pull the NAME of the employee, not just if they've been assigned. I was able to come up with a way to get the RID of the right team member - can I use that to fill a formula field or something?Many to Many team assignmentsHi, 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?