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.
Thanks, 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.