I have 2 tables "Risk" and "Team Members".
Team members -> Risks in a One to Many relationship.
The reference field in Risks is called "Assigned to" where I can select the team member to assign the risk to from a dropdown in forms.
I now want to change the "Assigned to" to a multi-select text because a risk needs to be assigned to multiple people.
How can I change it to multi-select without breaking the table relationship and reference?