@jen Stick with the common field among those, example I think is

entityid

and then use formula if needed and you would be fine...