Create a calculated field in table B that converts "Peterson, Johanson, Smith" into
and then use that as the parameter. An "= relationship" will match any value in the list, where the match field contains a list.
Simplest approach for the calc would probably be Substitute ( Names ; [ ", " ; ¶ ] ; [ "," ; ¶ ] ; [ " " ; ¶ ] )
I'll give this approach a go - I'm not sure if the names are structured consistently enough for this to be a 100% accurate solution but I'll see how it goes for now.