I created an EMPLOYEE list with a FULL NAME field based on =[FIRST NAME]&" "&[LAST NAME].
I also created a VACATION list. I tried to create "lookup" column based on the EMPLOYEE - FULL NAME column. A bunch of other fields in the EMPLOYEE table are visible as possible "lookup" columns, but the FULL NAME column is not.
Are calculated fields not valid for Look Up type columns?