I may not be seeing this right, and if not, please allow me to apologize in advance…
It appears, though, that if you have two fields in the same table that auto-enter the same related value, only one will work.
can’t reproduce. Can you send a small example?