Creating a list based on another field

I have been trying to achieve this for years and we?ve done a few things to work around the issue. I have a team of people I want to dedicate to a project. I then want only that list of people to be selected within the tasks.

I created a List-User field then created another field converting the list user to text. This gives me all the people selected on one line separated by semicolons. When I then go to create a multi select field based off the text field I only get one checkbox with all the people selected from the List-User field on one line. I feel like I?m so close. Is there a way to convert the text field into a list? Would the multi select field pick that up?

I really wish this would be a part of one of the updates. It seems like something pretty basic for a project management app.

We?ve tried the team member table connected to the project table. I found this very clunky. It had its flaw were you could add the same person as many times as you wanted to a project.

At the moment we have about 9 different List-User fields labeled Project Manager, Designer 1, Designer 2, Website, etc. then on the task have a multi select list with all those roles. This works for us right now, but I also find this to be very clunky.

Any help?