I am putting task items into a schedule and assigning People who will work together to get the task done. The task is one line in the Schedule table. I have linked to the People table (fk_People) and then linked multiple people, depending on who is going to be working on the task.
I made a lookup field from the People table so only their first names show in the field (Name_F). Thus - if I have assigned Trevor and Matt to the task, their names show up as
in the lookup field. This is what I want to show up in the formula field.
I have made a formula field to bring together the name of the task and the first names of the people assigned to work together:
Name_Task & " - " & Name_F
My problem is that the formula returns the Name_F lookup so that it looks like this
I must be missing something - but I cannot figure out where to look to get the answer.