Search or Filter Problem

Dear all


I want some help for a "split form"

I working on a rooming list like

Eric - 1
Bertha - 1.1

Victor - 2
Peter - 2.1

To show the room sharing.

i want to query with criteria say -by search the name Eric, then it should also betha ( 1.1 ) as they are sharing room.

How can i do that ?

Eric

can we see how your sheet looks like @ this moment ?

Kind regards
Leo