I never recommend users entering a TAPE name when using AMA as the information is in the SOURCE FILE and that is used the same way TAPE is used for baseband captured workflows. Basically, a clip should not have both TAPE and SOURCE FILE values. There are exceptions like with WAV files that have a Tape name declared in the bEXT or iXML, Media Composer will have both.
The other exception for file based workflows is when clips are transcoded in a third party application like Resolve, the REEL becomes TAPE. But same rule applies, it is either TAPE or SOURCE FILE, but both is not a good idea.
What you can do is use Labroll or Camroll (or custom column) and duplicate the common metadata into via duplicate column, ALE merge, etc. Then when relinking, use “relink to selected” and choose Labroll or whatever column you used for the common reel/source.
Michael