User Profile

DavidChotin

Qrew Trainee

Joined 6 years ago

3 Posts1 LikeLikes received

View All Badges

User Widgets

Contributions

Re: Many to Many team assignments
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.
9 years ago Place Quickbase Discussions
19Views
0likes
0Comments
Re: Many to Many team assignments
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?
9 years ago Place Quickbase Discussions
22Views
0likes
0Comments
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 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?
9 years ago Place Quickbase Discussions
36Views
1like
4Comments