Multiple problems with Lists lookup columns not behaving as expected

Hi.

I am pulling my hair out trying to figure out two problems I’m having with Microsoft Lists, and I’d appreciate it if anyone here can help me.

Situation: I have created three source Lists (employees, supervisors, jobs) and-- so far-- one target list.

On my target List, I have three lookup columns referencing the aforementioned source Lists. On the surface everything looks fine, but upon closer examination two important features are not working.

Problem #1: On the target List the “Employees” column is set to “allow multiple entries”, and although the column does allow multiple selections, only the first selection is actually saved in the List. 

Problem #2: Also on target List, the lookup columns are set to “Deletions from Source list affect this List=NO”. And yet, if I delete any entries from the source Lists (say, employees who have left the company), they disappear from the target List as well.

These two settings seem fairly self-explanatory, so either I am missing something (entirely possible), or the settings simply don’t work as advertised. 

If anyone has any suggestions on how to fix these problems, I’d be grateful.

Thanks.