AnsweredAssumed Answered

Value List - 2nd Field Display Issues

Question asked by mquinn on Jul 30, 2018
Latest reply on Jul 30, 2018 by philmodjunk

This is about a value list. I have a table of students and a table of faculty. I use a portal via a join table to identify faculty who advise the students. I use a value list for this purpose. I have three calculations on the faculty table. Advisor full name; a last name, first initial calculation; and a backwards name calculation. The value list is pulling first field values from faculty_id and then using one of the calculation fields to display 2nd field values only, from which I have pulled advisor full and last name, first initial fields and those work fine. However, I want the backwards full name to pull from the value list but when I choose that calculation field, it comes up with the faculty ID only and no name. I have no clue as to why.....Here are my calculations for each:

 

Advisor Full Name: First&" "&Last

Backwards Full Name: Last&"," &First (Will not appear on value list)

Last + First initial: Last&", " & Left (First ; 1)&"."

 

Stumped as to why two work and one does not!

 

Screen Shot 2018-07-30 at 8.56.36 AM.png

Outcomes