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.
You could create a formula field where if Team A Employee RID is 1, show the name of that person by hard coding it in the formula. If you have a bunch of people or lots of changes in staff, this wouldn't be the best way but could work in limited situations. Another way would be to relate the team members to the projects table 4 times, one time for each team. Then, with your 4 summary fields from the P&E table, you can use those and automatically populate the reference fields by changing them to a formula numeric field type, with the formula for the Team A employee to project reference field being: [Team A Employee RID], the summary from the P&E table related employee field where team is A.