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!