I have a database with two tables, projects and project team that are linked (relation). I use the [Employee] field from the project team table as a multiple choice field in the project table. Being that the [Employee] field is text, I want to create another field which returns the user value of the employee selected in the drop down.
1.) What sort of formula field should I use here?
2.) Should I use a Case statement for the formula?
3.) What's the proper format of the formula statement (ToText or something else)?