Many to Many team assignments
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...
Forum Discussion
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.
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.
Oops 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?
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?