My team just got started using Quickbase to track coaching support. Our Quickbase Users are the Coaches within our organization. The way coaching is structured is as follows: some clients receive coaching as part of a Team of Clients, and other Clients receive individual coaching.
So far, we have successfully set up tables of Teams and Clients. (The relationship is that one Team may have many Clients.) When a Coach is assigned to a Team, then that Coach is also assigned to all Clients on that Team via a lookup field. So far so good.
Now, I would also like to be able to create Client records for everyone who is not on a Team. I would like to indicate the Coach for each of these Clients, if possible, in a way that is consistent with how the Coach name appears in the lookup field for Clients on Teams. As things currently stand, I can't enter a Coach name into the Lookup field that draws from Teams -- which I know is a good thing, but that I'd also like to work around it not, for my non-team-affiliated Clients.
So, what's my best work around? And, thanks!