Copying and pasting into linked fields

Hello!
I have created a student database and while the linking between tables worked as recently as last week, the copy/paste function appears not to work anymore. Specifically, on the ‘Contacts’ table (see screenshot), any time a new record (student) is added, I would like to copy and paste that name into other columns which link to other tables such that the names show up in those other tables. For example, as seen in the screenshot, I would like to copy and paste the name ‘Kamala Harris’ to ‘Snapshot_link’ such that it shows up on the Snapshot table. However, I’m unable to do so-- I get a ‘Pasting…’ message and nothing happens. Currently the Name field is a formula, but it won’t work even if I make it a single line text.